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

Home -> Community -> Mailing Lists -> Oracle-L -> Logminer question

Logminer question

From: Bill Becker <beckerb_at_mfldclin.edu>
Date: Fri, 12 Jan 2001 08:24 CST
Message-Id: <10739.126491@fatcity.com>


}]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). Received on Fri Jan 12 2001 - 08:24:00 CST

Original text of this message

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