.on.ca> cc:
Sent by: Subject: Script to Turn Off All Oracle
Auditing 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
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 on a
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 database here with about 600 Oracle users defined
in dba_users. However, likely one half or more of the defined users no
longer connect to the database. I want to purge out the users that do
