Oracle Audit

Vogra — Thu, 23 Aug 2001 19:46:56 GMT

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.

Re: Oracle Audit

LBertoglio — Fri, 24 Aug 2001 06:40:54 GMT

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

topic Oracle Audit in Operating System - HP-UX

Oracle Audit

Re: Oracle Audit