oracle怎么开启精细审计,oracle精细审计

建立精细审计：

EXEC dbms_fga.add_policy(object_schema=>'schema_name',object_name=>'table_name',policy_name=>'CHK_table_name',statement_types=>'SELECT,INSERT,DELETE,UPDATE');

查看已设置的精细审计：

SELECT * FROM DBA_AUDIT_POLICIES;

删除精细审计：

EXEC dbms_fga.drop_policy(object_schema=>'schema_name',object_name=>'table_name',policy_name=>'CHK_table_name');

禁用精细审计：

EXEC dbms_fga.disable_policy(object_schema=>'schema_name',object_name=>'table_name',policy_name=>'CHK_table_name');

启用精细审计：

EXEC dbms_fga.disable_policy(object_schema=>'schema_name',object_name=>'table_name',policy_name=>'CHK_table_name');

查看审计结果：

SELECT * FROM dba_fga_audit_trail;

删除审计结果：

DELETE FROM sys.fga_log$;