Good afternoon! I'm working with Oracle Database 12c and I'm having a little trouble with auditing. How to remove audit entries from UNIFIED_AUDIT_TRAIL?

Question

Oracle

While running, Oracle Database collects data about activity, users, and so on. I figured out how to collect data and set up security policies. But the problem is that the audit log is too big. In the documentation I found a PL / SQL script with which you can delete records, but it does not work. How to remove audit records from UNIFIED_AUDIT_TRAIL table?

Answer 1

To remove audit records from the UNIFIED_AUDIT_TRAIL table, the authorized user must be assigned the AUDIT_ADMIN role.
To implement this step, you need to run the command:
Log in to Oracle Database with the given user.
Set the user to the AUDIT_ADMIN role. To implement this step, you need to run:
Then execute the command:
BEGIN
DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL(
AUDIT_TRAIL_TYPE => DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED,
USE_LAST_ARCH_TIMESTAMP => FALSE,
CONTAINER => DBMS_AUDIT_MGMT.CONTAINER_CURRENT );
END;
/