添加策略BEGINdbms_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$ 表所在表空间BEGINDBMS_AUDIT_MGMT.set_audit_trail_location(audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_FGA_STD,audit_trail_location_value => 'USERS');END;/
