Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Audit Log for Analytics > Administration > Manage Privileges
Audit logs required for Oracle Analytics Server > Administration > Manage privileges
Comments
-
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).
0 -
Can you please provide the schema and table name where we can find the details in Database
0 -
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.
0 -
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:
Alternatively you can use the SOAP API getGlobalPrivileges:
Creating queries against the BIPlatform schema to reverse engineer a solution is not a supported approach so at your own risk.
0 -
I've marked this Idea as 'current capability' although I accept there is no event-based audit.
0
