Answer the question
In order to leave comments, you need to log in
How to exclude a single user from an audit?
Good afternoon, please tell me how to exclude one user from the audit?
SELECT owner, object_name, object_type, del, ins, upd FROM dba_obj_audit_opts
HR t12 table s/ss/ss/s
-------------------------- -----------------------
SELECT audit_option, success, failure FROM dba_stmt_audit_opts
user BY ACCESS BY ACCESS
table BY ACCESS BY ACCESS
Exclude test1
NOAUDIT UPDATE TABLE, INSERT TABLE, DELETE TABLE BY test1
does not give results, all actions from test1 are also written to the aud$ table
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question