RE: Oracle Auditing

From: Justin Cave (DDBC) <jcave_at_ddbcinc.com>
Date: Mon, 17 May 2004 08:17:56 -0600
Message-ID: <87E9F113CEF1D211A4C30090273018742BCA08@ddbcinc.ddbc.local>

Pete Finnigan has a few excellent papers http://www.petefinnigan.com .

Oracle provides a "unsupported" script that moves the audit table into another tablespace on Metalink. My understanding is that a fair number of DBA's use this script in production and nothing catches on fire, but it's still technically unsupported.

Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Smith, Ron L. Sent: Monday, May 17, 2004 8:02 AM
To: oracle-l_at_freelists.org
Subject: Oracle Auditing

Our Auditors want us to turn on auditing in all production databases. =3D20 They would like us to audit failed logon attempts, DML activity, = and
use of DBA privileges.

Does anyone have a good paper or link that shows the basic steps of setting up auditing, specifying the parameters, etc...

Also, is there a way to move the audit table to it's own tablespace in 7.3.4, 8.1.7, 9?.

Thanks!
Ron

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Mon May 17 2004 - 09:13:27 CDT