audit by user by table
看联机文档audit语法应该可以实现，实际上确不能。
T@ bip> audit select,insert,update,delete on t.t by ys;
audit select,insert,update,delete on t.t by ys *
ERROR at line 1:
ORA-01708: ACCESS or SESSION expected
audit select,insert,update,delete on t.t by ys *
ERROR at line 1:
ORA-01708: ACCESS or SESSION expected
I wanted to audit dml by user by table,but I can not.Use FGA instead.
BEGIN
DBMS_FGA.ADD_POLICY(
object_schema => 'T',
object_name => 'T',
policy_name => 'chk_t',
audit_condition => 'sys_context(''userenv'',''session_user'')=''TT''',
enable => TRUE,
statement_types => 'INSERT, UPDATE, SELECT, DELETE',
audit_trail => DBMS_FGA.DB);
END;
/
DBMS_FGA.ADD_POLICY(
object_schema => 'T',
object_name => 'T',
policy_name => 'chk_t',
audit_condition => 'sys_context(''userenv'',''session_user'')=''TT''',
enable => TRUE,
statement_types => 'INSERT, UPDATE, SELECT, DELETE',
audit_trail => DBMS_FGA.DB);
END;
/
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/756652/viewspace-722623/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
