cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle Audit

SOLVED
Go to solution
Vogra
Regular Advisor

Oracle Audit

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.
We are spirits in the material world
1 REPLY
LBertoglio
Advisor
Solution

Re: Oracle Audit

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