Audit data pump export operations with unified Auditing policy

1. Create an Audit policy

Sql> alter session set CONTAINER=PDB1; sql> Create or replace directory Dumpdir as '/u12/app/dumpdir '; Sql> Grant Read,write on directory Dumpdir to Scott; Sql> Create audit Policy dp_01 actions component=datapump export;

2. Open Audit Policy

Sql> Audit Policy dp_01;

3. Perform a data pump export operation

$ EXPDP scott/[email protected]  Dumpfile=scott_schema Directory=dumpdir

4. Refresh data to disk

sql> exec Sys.dbms_audit_mgmt.flush_unified_audit_trail;

5. View Unified_audit_trail

Sql> Select Dp_text_parameters1,dp_boolean_parameters1 from Unified_audit_trail where dp_text_parameters1 are not Null;dp_text_parameters1                                                              Dp_boolean_ PARAMETERS1---------------------------------------------------------------------------------------------------- ------------------------------------------------------------MASTER TABLE: "  SCOTT". " Sys_export_schema_01 ", Job_type:export, Metadata_job_m master_only:false, Data_only:false, Metadata_only:false, DUMP FILE_PRESENT:TRODE:SCHEMA_EXPORT, JOB version:12.1.0.2.0, ACCESS method:automatic, DATA OPTI UE, Job_restarted:falseo ns:0, Dumper directory:null  

Audit data pump export operations with unified Auditing policy