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

Home -> Community -> Usenet -> c.d.o.server -> Re: Tracking "selects"

Re: Tracking "selects"

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 28 Jun 2005 19:53:17 +0200
Message-ID: <d9s2fs$cl8$2@news1.zwoll1.ov.home.nl>


LineVoltageHalogen wrote:
> Does Oracle keep track of the "selects" issued against the database in
> the redo/archived logs? I need to know who viewed what data.
>
> Thanks.
>

Logminer can be used to track changes through redo. Not sure about selects.
Looks like you need Auditing? It's there, just not switched on by default (maybe that could change with 10g Rel.2 - all sox compliant and all that)

-- 
Regards,
Frank van Bortel
Received on Tue Jun 28 2005 - 12:53:17 CDT

Original text of this message

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