添加策略

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;

/