show parameter audit_trail;
begin
dbms_fga.add_policy(object_schema => 'KDCC',----所有者
object_name => 'XJY_1',----表名
policy_name => 'XJY_1_ACCESS',---审核策略名称,自定义
audit_condition => 'C=12',---审计条件
audit_column => 'C',---审计列
statement_types => 'UPDATE');---'INSERT, UPDATE, DELETE, SELECT'
end;
----注意看审计列,但未包含的时候是不被审计的,只包含一个的时候也会被审计
begin
dbms_fga.add_policy (
object_schema => 'KDCC',
object_name => 'XJY_1',
policy_name => 'XJY_1_ACCESS',
audit_column => 'b,c',
---- audit_condition => 'C=12',
statement_types => 'UPDATE'
--- audit_column_opts => DBMS_FGA.ALL_COLUMNS,
--- audit_trail => 'DB'
);
end;
select a.extended_timestamp,
a.db_user,
a.os_user,
a.userhost,
a.object_name,
a.sql_text
from dba_common_audit_trail a
where object_name = 'XJY_1';
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30180323/viewspace-2144531/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30180323/viewspace-2144531/