Auditing Oracle Roles with Unified Auditing

In Oracle 12c and later versions, auditing is possible with Unified audit as well as standard auditing. This feature allows role-based auditing. It is possible to audit the activities of any roles by defining role based policies with unified audit.

Create and enable a policy to audit DBA Roles

Create Audit Policy

You can create an audit policy with the below script.

Enable Audit Policy

Then, if we enable this policy as follows, audit records of transactions performed by DBA users will now be accessible from the UNIFIED_AUDIT_TRAIL view.

You can enable Unified Auditing feature by reading the article below.

“How To Enable and Disable Unified Auditing Feature in Oracle”