審計--audit

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;