使用Unified Auditing Policy审计数据泵导出操作

2015-12-07 10:20 abce 阅读(546) 评论(0) 编辑收藏举报

1.创建审计策略

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.开启审计策略

1	`SQL> audit policy dp_01;`

3.执行数据泵导出操作

1	`$ expdp scott/tiger@pdb1 dumpfile=scott_schema directory=dumpdir`

4.刷新数据到磁盘

1	`SQL> exec sys.dbms_audit_mgmt.flush_unified_audit_trail;`

5.查看unified_audit_trail

SQL> select dp_text_parameters1,dp_boolean_parameters1 from unified_audit_trail where dp_text_parameters1 is 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, DUMPFILE_PRESENT: TR
ODE: SCHEMA_EXPORT, JOB VERSION: 12.1.0.2.0, ACCESS METHOD: AUTOMATIC, DATA OPTI UE, JOB_RESTARTED: FALSE
ONS: 0, DUMPER DIRECTORY: NULL  REMOTE LINK: NULL, TABLE EXISTS: NULL, PARTITION
 OPTIONS: NONE
SQL> 