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;

ITPub博客

审计--audit

最新文章