Re: Logging updates

From: Michael Austin <>
Date: Mon, 02 Mar 2009 14:11:35 -0600
Message-ID: <V5Xql.20883$> wrote:
> 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.

Yes- mostly...
  hint: v$session.

> 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 - 14:11:35 CST

Original text of this message