BI Publisher (MOSC)

MOSC Banner

Does BI Publisher check SQL queries for "delete" or "update" keywords?

edited Feb 9, 2016 4:04PM in BI Publisher (MOSC) 1 commentAnswered ✓

Does BI Publisher check SQL queries for "delete" or "update" keywords?

As I understand BI Publisher allows to create report, based on SQL

for ex "select * from usr where usr_create> sysdate -30"  -- report for people hired in last 30 days, create xls, deliver by email..

is there any restriction on BI Publisher level kind of "select queries only", "no update-delete queries allowed"

or that thing need to be controlled on DB level, kind of "here is ReadOnly User", "create DB connection with that user and run reports"

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center