That's correct. The poster didn't specify which version. If it's 9i the options available are plenty.
Arup Nanda ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, June 11, 2003 10:19 AM > Beware that user SYS is not AUDITable in 8i... > > Rich > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > > > > -----Original Message----- > > From: Arup Nanda [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, June 11, 2003 1:14 AM > > To: Multiple recipients of list ORACLE-L > > Subject: Re: Database Auditing > > > > > > Ravindra, > > > > I'm not sure I understand the question correctly. Statement > > level auditing? > > Are you referring to recording that a particular statement > > was executed on a > > specific table? If so, the plain vanilla AUDIT statement is > > for you. There > > is no need for any triggers to be set up. > > > > If you want more elaborate, which rows the user updated, etc. > > you have a > > challenge. In Oracle 8i, you could go to log miner to mine > > all statements > > that modified data. Thi swill capture all but the SELECT > > statements. In > > Oralce 9i, there is a new feature called Fine Grained > > Auditing that can > > capture the exact statement the user issued and can even > > audit on based on > > the predicate of the select query. If youwant some > > moreinformation on the > > FGA, let me know. > > > > If you want to capture the DDL changes, the best option is to > > use system > > level triggers. > > > > I am not sure what you mean by OS level auditing of statements. > > > > HTH. > > > > Arup Nanda > > Author of the forthcoming book "HIPAA Security and Auditing > > for Oracle" from > > Rampant TechPress (www.Rampant.cc) > > > > > > > > ----- Original Message ----- > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Wednesday, June 11, 2003 12:04 AM > > > > > > > Hi All, > > > > > > How do we turn on statement level auditing (DB and OS > > Level) to audit the > > > DML/DDL's on the database.Is this possible with out triggers? > > > > > > Thanks > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jesse, Rich > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).