Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: audit select statements
"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