Oracle Audit

[Vogra]

Hi All!
I set the audit in one table on Oracle 8.1.6. How can I disable the specificaly audit like select or insert on it? Or, how can I disable the audit in one table.
Thanx.

[LBertoglio · Accepted solution]

Hi,
you can stop auditing with the "noaudit" command.
e.g. you can stop auditing select on scott's emp table with:
noaudit select on scott.emp;

You can see which objects you are auditing for select with:
select object_name, object_type
from dba_obj_audit_opts
where sel != '-/-'
/

Hope this could help;
Bye