利用FGA审计
增加FGA
begin
dbms_fga.add_policy(object_schema => 'hr',
object_name => 'test',
audit_column => 'name',
policy_name => 't1_audit',
statement_types => 'update'
);
end;
删除FGA
begin
DBMS_FGA.DROP_POLICY(object_schema => 'hr',
object_name => 'test',
policy_name => 't1_audit');
end;
from dba_fga_audit_trail order by timestamp;
select * from dba_audit_policies;
begin
dbms_fga.add_policy(object_schema => 'hr',
object_name => 'test',
audit_column => 'name',
policy_name => 't1_audit',
statement_types => 'update'
);
end;
删除FGA
begin
DBMS_FGA.DROP_POLICY(object_schema => 'hr',
object_name => 'test',
policy_name => 't1_audit');
end;
from dba_fga_audit_trail order by timestamp;
select * from dba_audit_policies;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/24486203/viewspace-1698688/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
