Does BI Publisher check SQL queries for "delete" or "update" keywords?
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"