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: track user's select statements

Re: track user's select statements

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 22 Nov 2006 11:18:14 -0800
Message-ID: <1164223095.203378@bubbleator.drizzle.com>


cobra wrote:
> Hi:
> I want to track select statements executed by a user on some
> tables,any ideas?
> Thanks for the Help.

What version of Oracle? For what purpose?

There are a number of ways to accomplish this depending on version including:

Fine Grained Auditing
Streams
Change Data Capture
Log Miner
Triggers

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Nov 22 2006 - 13:18:14 CST

Original text of this message

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