DBA Hub

📋Steps in this guide1/1

Enable auditing for datapump jobs

-- Create policy

oracle configurationintermediate
by OracleDba
12 views
1

Enable auditing for datapump jobs

-- Create policy -- Enable policy -- View audit report:

Code/Command (click line numbers to comment):

1
2
3
create audit policy expdp_aduit actions component=datapump export;
audit policy expdp_aduit;
select DBUSERNAME,DP_TEXT_PARAMETERS1 from UNIFIED_AUDIT_TRAIL where DP_TEXT_PARAMETERS1 is not null;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!