-
AUDIT on a table for everyone except one !!
Is it possible to audit everyone except for one user on a certain DB object.
EG: Is it possible (I don't want to audit XXX for accessing the table but everyone else).
audit select,insert,delete,update on OWNER.TABLE_NAME;
noaudit select,insert,delete,update on OWNER.TABLE by XXX;
-- I'm getting the following error on the second statment.
ERROR at line 1:
ORA-01708: ACCESS or SESSION expected
-
Issue goes a little deeper.
The NOAUDIT option only negates an audit statement with the same syntax.
It is not possible to exclude certain users from current audit options unless the original audit statement included the "BY" clause.
You can always issue AUDIT command specifying the list of users you want to audit, it can be painful but it can be done.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
So what's the syntax to audit user A,B, C for select ,update,delete on owner.table_name ?
-
audit select table, update table, delete table by UserA, UserB, UserC by access;
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|