Re: help with user trace needed

If you have every user using their own Oracle user account, you could write a trigger against the table in question and write the username and time of update and also what was changed to a temporary table.

If all users connect via a generic account you will need to consider other options....

Cheers, Robert Prendin

Mikhail Galbmillion <galbmill_at_21st-century-comm.com> wrote:

>Hello,
>
>I need to trace a user(user machine) who tries to add some
>entry to database table. The data is entered on
>web page and is inserted to database using Oraperl.
>I just need to keep track of users who use this web page and execute
>"insert" opertion. How can I do it in Oracle environment
>
>Appreciate your help.
>Thank you,
>Mikhail Galbmillion
>galbmill_at_21st-century-comm.com
Received on Wed Mar 18 1998 - 00:00:00 CST