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: cobra <rock252_at_126.com>
Date: 23 Nov 2006 02:58:57 -0800
Message-ID: <1164279536.981568.30490@e3g2000cwe.googlegroups.com>

On 11月23日, 上午3时18分, DA Morgan <damor..._at_psoug.org> wrote:
> 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
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

thanks
The version is Oracle 8.1.7.4, Can Fine-Grained Auditing work? I think trigger is a good idea,but how to track select statements using trigger?
I want to track the whole select statement when a user select some columns on a table. Received on Thu Nov 23 2006 - 04:58:57 CST

Original text of this message

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