Logminer question

}]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