Re: audit select statements

From: Quarkman <quarkman_at_myrealbox.com>
Date: Sun, 13 Jul 2003 07:31:15 +1000
Message-ID: <oprr7vedaor9lm4d@haydn>

On Sat, 12 Jul 2003 20:57:08 +0300, Roger Nukemaster <roger.nukemaster_at_mail.ee> wrote:

> Hei,
>
> If I search from google I find only how select sql contetns from v$sql
> or
> .....
> but i want make like triggers with select statement.
>
> If user select from table I want to oracle automatically save user sql
> contents and user name into some table.

You haven't mentioned a version, so it's a bit tricky to offer help.

But if it's 9i, look in the manual regarding 'Fine Grained Auditing' (not to be confused with Fine Grained Access Control, aka Virtual Private Database aka Row-level Security).

~QM Received on Sat Jul 12 2003 - 16:31:15 CDT