Logging updates

From: <amerar_at_zacks.com>
Date: Mon, 2 Mar 2009 10:02:18 -0800 (PST)
Message-ID: <4d90320f-96c9-49ae-8ef5-66974525ffbd_at_q30g2000prq.googlegroups.com>

Is it possible to create a trigger that will show me the following:

Which user performed the update
Who procedure performed the update
The SQL string that was used.

I can probably get the SQL from v$SQL. But Who and What performed the update is a bit more complex I think.

WHO_CALLED_ME is not really what will do the job here.....

Thank you. Received on Mon Mar 02 2009 - 12:02:18 CST

Original text of this message