Re: Oracle Auditing

Hi Roland,

You can use row triggers to capture information such as which user is performing modifying the table, and before/after values of each of the columns. Oracle's documentation included a long discussion on the use of triggers in auditing.

I don't know if its possible to capture the exact SQL that was used to modify a table.

O'Reilly has a good book on this topic: "Oracle Security" by Theriault and Heney.

• Dale Shultz

"Meier Roland" <Roland_Meier_at_freesurf.ch> wrote in message news:<9sqoko$45c$1_at_rex.ip-plus.net>...
> Hello there
>
> I would like to audit insert, update and delete statemtens on a specific
> table.
>
> Is it possible to see all the exact statements a user has processed on this
> table ? Can anyone tell me where I can see this.
>
> I am a little bit confused about the sys tables.
>
> Thank you very much
>
> Roland
Received on Tue Nov 13 2001 - 11:24:02 CST