Re: Logging updates

From: Michael Austin <maustin_at_firstdbasource.com>
Date: Mon, 02 Mar 2009 14:11:35 -0600
Message-ID: <V5Xql.20883$yr3.4860_at_nlpi068.nbdc.sbc.com>



amerar_at_zacks.com 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