Re: audit select statements

From: Roger Nukemaster <roger.nukemaster_at_mail.ee>
Date: Sat, 12 Jul 2003 20:57:08 +0300
Message-ID: <3F104BF4.9050009@mail.ee>

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.

Daniel Morgan wrote:
> Noons wrote:
>
>

>>"Anurag Varma" <avarmadba.skipthis_at_yahoo.com> wrote in message
>>news:o5WPa.3868$Y92.353_at_nwrdny01.gnilink.net...
>>
>>
>>>>For example:
>>>>I have table 'emp' and users select from this table some info.
>>>>Now I want to now what is the user name who select and SQL statement
>>>>contensts.
>>>
>>>Lately there has been a flood of these kind kind of requests.
>>>Search in Google /  in this newsgroup.
>>>
>>
>>Wanna bet there is gonna be some "announcement"
>>from the competition?
>>Sooooooo predictable...
>>--
>>Cheers
>>Nuno Souto
>>wizofoz2k_at_yahoo.com.au.nospam

>
>
> Or some instructor assigned it as homework. But yes ... so very very
> predictable.
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
>
Received on Sat Jul 12 2003 - 12:57:08 CDT