Re: Logminer question

Nope on selects as select statements are not found in redo logs.

you'll have to use auditing.

joe
Bill Becker wrote:
>
> }]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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Bill Becker
> INET: beckerb_at_mfldclin.edu
>
> 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).

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