RE: Audit

Have you done a quick query against dba_audit_trail?

That will tell you whether Oracle is collecting the auditing information at all.

If you think you will audit a lot of info, consider moing the aud$ table out of the SYSTEM tablespace, there is a technical note on Metalink on how to do that.

Regards,
Pat.

> -----Original Message-----
> From: Aldi Barco [SMTP:ipal_at_hotmail.com]
> Sent: Wednesday, December 06, 2000 5:16 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Audit
>
> Hi folks,
>
> I would like to audit who has dropped a table.
> I've set audit_trail=os in the init.ora and invoke
> from SQL > audit drop any table by user1;
> But, if user1 dropped a table, there is no information
> in the audit_trail_dir telling me that user1 has dropped
> a table.
> Anything else that I need to set ?
> Oracle 816, Linux2.6.
>
> Tia,
>
> Aldi
> oracle DBA
>
> __________________________________________________________________________
> ___________
> Get more from the Web. FREE MSN Explorer download :
> http://explorer.msn.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Aldi Barco
> INET: ipal_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Thu Dec 07 2000 - 06:12:36 CST