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.
I am creating two tables in a freeform report and overlaying these tables to appear as one to the end user. I can hide the header titles by setting the font and highlight colour to the same as the background colour but it would be better if there was a functionality to disable the header row completely.
My organization needs a practical way to generate a comprehensive report listing all members—including both direct and inherited assignments—of every custom application role within the Oracle Analytics Cloud (OAC) Console’s Roles and Permissions area. Today, the only built‑in method is exporting one role at a time through…
Currently you are able to change the width of a field in a table or pivot table by dragging the border but there is no option to manually fix it to a set value e.g. 100px. Justification: I am creating a report with two tables in freeform and need the field widths to have the same size when I overlay one table on the other.…
Request for an enhancement to Oracle Analytics Cloud (OAC) Classic Analysis Selection Steps on measure suppression for a specific calculated member created through Selection Steps. This idea is opened based on the directions from oracle CEAL team, for more details please find the below service request. SR -…
Hi, We use a lot of Custom App Roles in OAC Console and It would be easier to have an API to manage the members of App Roles.