添加策略
BEGIN
dbms_fga.add_policy(
object_schema => 'test',
object_name => 't',
policy_name => 'AUDIT_PROVISIONING_DATA1',
audit_condition => 'SYS_CONTEXT(''USERENV'',''SESSION_USER'') not in (''TEST'')',
enable => TRUE,
statement_types => 'INSERT,SELECT,UPDATE,DELETE',
audit_trail => DBMS_FGA.DB+DBMS_FGA.EXTENDED);
END;
/
删除策略
BEGIN
dbms_fga.drop_policy(
object_schema => 'test',
object_name => 't',
policy_name => 'AUDIT_PROVISIONING_DATA1',
);
END;
/
修改FGA_LOG$ 表所在表空间
BEGIN
DBMS_AUDIT_MGMT.set_audit_trail_location(
audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_FGA_STD,
audit_trail_location_value => 'USERS');
END;
/
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/31519308/viewspace-2726482/ ，如需转载，请注明出处，否则将追究法律责任。
