ORACLE FGA 精细化审计

FGA精细化审计:
select * from liso.test1;

show parameter audit;
--创建审计策略
exec dbms_fga.add_policy(object_schema=>'liso', object_name=>'test1', policy_name=>'check_test1_object_id',audit_condition=>'object_id=16894',audit_column=>'object_id',statement_types => 'UPDATE');

--执行dml语句
update TEST1 set object_id=222 where object_id=16894;

--查询审计结果
select * from dba_fga_audit_trail;

--停用审计策略
exec dbms_fga.disable_policy(object_schema=>'liso',object_name=>'test1',policy_name=>'check_test1_object_id');

--启用审计策略
exec dbms_fga.enable_policy(object_schema=>'liso',object_name=>'test1',policy_name=>'check_test1_object_id');

--删除审计策略
exec dbms_fga.drop_policy(object_schema=>'liso',object_name=>'test1',policy_name=>'check_test1_object_id');

--删除精细审计结果
delete from sys.fga_log$;

SELECT * FROM SYS.fga_log$;

--查看已经设置的审计策略 
SELECT * FROM DBA_AUDIT_POLICIES;