Re: Logminer question

From: Jim Conboy <Jim.Conboy_at_trw.com>
Date: Fri, 12 Jan 2001 12:15:09 -0500
Message-Id: <10739.126527@fatcity.com>

Why not turn on the built-in auditing features?

>>> beckerb_at_mfldclin.edu 01/12/01 09:26AM >>>
}]mCl#Please Confirm[{
Hello,

My env is Oracle 8.1.6 on Solaris 2.7.

I know logminer can be used to track inserts, updates, deletes, but can it also be used to track select statements? I'm thinking of a situation where we want to identify everyone who accessed a certain record or a group of records in an Oracle table in any way, even if they only viewed records.

Given a certain record in some table identified by some unique key, is there any way to search v$logmnr_contents to find anyone who has viewed that record?

The reason for these questions is that we may have some very strict auditing requirements forced upon us; I'm hoping the already-existing redo log system is satisfactory, otherwise, this becomes a major project.

Thanks (probably to JoeT).
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20 --=20
Author: Bill Becker
  INET: beckerb_at_mfldclin.edu=20

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 Fri Jan 12 2001 - 11:15:09 CST