Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Audit

Audit

From: Aldi Barco <ipal_at_hotmail.com>
Date: Thu, 07 Dec 2000 04:13:02 +0700
Message-Id: <10702.123851@fatcity.com>


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 Received on Wed Dec 06 2000 - 15:13:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US