A
A
Andrey San2014-12-08 08:00:19
Oracle
Andrey San, 2014-12-08 08:00:19

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 question

Ask a Question

731 491 924 answers to any question