Get privilege to issue logical SQL in OTBI
Summary
As a developer i need to "Issue SQL" /analytics/saw.dll?issuerawsql to query using logical sql metadata repository database (rpd) with log level 2 then view log for diagnostics like physical sqlContent
Hi,
Does anyone know if in Oracle Cloud Application, we are oracle cloud application 19B(11.13.19.04.0) with oracle business intelligence 11g (11.1.1.9.0), does a role exist that has been granted privilege "Admin:General"/"Issue SQL Directly" by person with bi administration privileges who went to the Administration menu then the page "Manage Privileges" to assign that privilege to a role. Our development team who are writing extensions using oracle transaction business intelligence (OTBI) real time subject areas, to be productive, need the ability to issue logical sql, view results with the log level set > 0, then view the log file with rich diagnostics like timings and row counts