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

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;
/

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/756652/viewspace-722623/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/756652/viewspace-722623/