Title: RE: Script to Turn Off All Oracle Auditing Options?
To create the audit trail views, run cataudit.sql.
To delete the audit trail views, run catnoaud.sql.
To find out which are the active options, use this statement:
SELECT * FROM sys.dba_priv_audit_opts;
or for audit options
In my previous message, I forgot to say:
You could always use the scorched earth approach and change everyone's
password. Then see who complains that they can't log in. :)
-Original Message-
We are running Oracle 7.3.4.5.0 on an IBM/AIX RISC System/6000: Version
2.3.4.0.0.
I have a
I see yet another poor soul still supporting V7.3.4.5 as I am doing on V2.6
Solaris.
You should be warned that on a couple of different occasions (I'm a slow
learner)
when I launched a SQL script which changed AUDITing on hundreds of objects,
Oracle went bonkers. It appearded as though the