Which tables should be used for reporting users, roles and actions to generate reports using SQL?

User_6W1ET

The cybersecurity area has been asking for more detailed traceability of user management in the CX application. We are currently trying to generate reports from the Reports and Analytics module.

At the moment we do not know which entities contain the fields we need to reflect. We have tested with opportunity tables, but we really need to identify which ones fit our needs.

To carry out the audit control, the following fields would be needed for correct control:
-Username
-Full name
-Roles
-Creation date
-Creation user
-Last update date
-User latest update
-Last update made
-Last connection date (or days of inactivity)

Mallikarjuna Kuppauru-Oracle

Hi @User_6W1ET

I hope you can able to get the same from IDCS refer below -

https://blogs.oracle.com/observability/post/how-to-send-idcs-audit-logs-to-oci-logging-analytics-and-get-insights

Regards,

Arjun

Ashish-Oracle

@User_6W1ETThis forum is dedicated to FDI. From your issue description it looks like your question is more on the Fusion CX security.

For any queries related to Fusion in future please reach out to our sister Fusion Community

https://community.oracle.com/customerconnect/