Re: LogMiner and Auditing

Nope, not auditing as in the pure essence of auditing like oracle auditing.

But I've done the concept of pin pointing what user dropped a table based on the DML of the dictionary tables, tab$, col$, etc.

So thats an extreme subset at best. Besides with oracle auditing you can audit select statements(if i remember correctly), where as logminer only does DML against tables and with some serious investigative work DDL against tables(which in reality is only DML against the data dictionary).

hth, joe

jkstill_at_cybcon.com wrote:

<SNIP OF THE STORY>

> Seriously, has anyone successfully used LogMiner for auditing
> in a production database.
>
> Joe, your input here would be appreciated.
>
> Jared

-- 
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joseph S. Testa
  INET: teci_at_oracle-dba.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).