truncate table sys.audit$;          --如果业务繁忙会造成审计表越来越大，可以定期删除，而且建议将此表move至其他数据表空间，默认在system
select * from sys.fga_log$;
select * from dba_audit_policies; --审计策略


select * from dba_fga_audit_trail;   --细粒度审计
select * from dba_common_audit_trail where db_user='SCOTT';   --查看标准审计行和细粒度的审计行
select * from DBA_AUDIT_STATEMENT;
select * from DBA_STMT_AUDIT_OPTS;
SELECT * FROM SCOTT.SC_PAY_LS;
SELECT * FROM SCOTT.SC_TN_LS;
--删除策略
/*begin
  dbms_fga.drop_policy('SCOTT','SC_PAY_LS','SCOTT_PAYLS');
  dbms_fga.drop_policy('SCOTT','SC_TN_LS','SCOTT_TRANLS');
  end;*/
--增加策略，只针对字段的update-delete操作审计
begin 
  dbms_fga.add_policy(object_schema=>'SCOTT',object_name=>'SC_PAY_LS',policy_name=>'SCOTT_PAYLS',statement_types => 'UPDATE,DELETE',audit_column => 'T1,B2');
  dbms_fga.add_policy(object_schema=>'SCOTT',object_name=>'SC_TN_LS',policy_name=>'SCOTT_TNLS',statement_types => 'UPDATE,DELETE',audit_column => 'T1');
  end;