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: audit select statements

Re: audit select statements

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Sun, 13 Jul 2003 21:31:42 +0100
Message-ID: <3f11c1fd_1@mk-nntp-1.news.uk.worldonline.com>


"Quarkman" <quarkman_at_myrealbox.com> wrote in message news:oprr7vedaor9lm4d_at_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).
>

What's it got to do with fine grained auditing? This is simple auditing.

Regards,
Paul Received on Sun Jul 13 2003 - 15:31:42 CDT

Original text of this message

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