Audit logs required for Oracle Analytics Server > Administration > Manage privileges
Because the privileges are stored in the catalog, if the fields of "modified_by_name" and "modified_by_type" would behave like everything else in the catalog, the job would be done already and could be tracked with database auditing.
But apparently for the privileges these attributes of the catalog objects stay null all the time (while "modified_time" is correct).
Can you please provide the schema and table name where we can find the details in Database
It's the main catalog table css_si_files in the biplatform schema. But as said, the privileges are missing that info on the modification.
We do not have event-based audit for these privileges but you can run periodic reports to list who has these privileges. Please review the OAS docs for using runcat to report classic privileges:
https://docs.oracle.com/en/middleware/bi/analytics-server/security-oas/use-runcat-manage-security-tasks-presentation-catalog.html
Alternatively you can use the SOAP API getGlobalPrivileges: https://docs.oracle.com/middleware/12213/biee/BIEIT/methods.htm#i1009858
Creating queries against the BIPlatform schema to reverse engineer a solution is not a supported approach so at your own risk.
I've marked this Idea as 'current capability' although I accept there is no event-based audit.
OAS Classic Report Results display the first 5000 rows and the OAS user needs to click the next button for the next 5000 rows and so on. The 5000 row limit is the maximum allowed to be setup in the OAS Console. OBIEE Report Results support display of the entire report results data set. Our users would like this feature in…
Background We recently identified an issue through an inconsistency in the number of records returned in an API response. This allowed us to notice, after the fact, that a fix had been applied that changed the behavior of an existing API. Problem We understand that information about resolved bugs is eventually made…
We need a way for non-admin users to view the backend/physical SQL queries executed by reports (via Session and Query Logs) without granting them full administrator access. OAC's custom Application Role model (Console > Roles and Permissions) allows selecting fine-grained permissions instead of assigning predefined roles.…
Customer would like to request that IBM DB2 12.x be added as a supported data source for Oracle Analytics Server. They hope that it will be included as a certified and supported data source in the next(Year 2027 ) OAS release. Background: The customer is currently operating a reporting and analysis platform using Oracle…
We would like to restrict the MCP to certain OAC application roles instead of all the users. Please help us to achieve this functionality.
