Re: How could I know who fires a trigger ???

From: Steve <steve.hollings_at_ecrossnet.com>
Date: Wed, 23 May 2001 14:13:21 +0100
Message-ID: <3b0bb7ac$0$12245$ed9e5944@reading.news.pipex.net>

within the DB After trigger use code to insert into a shadow table (to record amendment logging) and insert the following variables:

user, sysdate and userenv('TERMINAL')

To see what this would give test them out in SQL using

select user, sysdate, userenv('TERMINAL') from dual;

"David PEYRIERES" <david.peyrieres_at_meteo.fr> wrote in message news:3B0B5EDD.52CBB6A2_at_meteo.fr...
> Hello,
>
> I'd want to survey the transactions which occur in my database and
> precisely who are the users who fires some triggers.
> Do you have any suggestions ???
>
> Thanks.
>
> --
> -------------------------------------------------------------------
> David PEYRIERES
> METEO FRANCE
> DP/CBD/BD Tél : 05 61 07 83 36
> Av G.Coriolis mailto: david.peyrieres_at_meteo.fr
> 31057 TOULOUSE CEDEX http://www.meteo.fr
> -------------------------------------------------------------------
>
>
Received on Wed May 23 2001 - 08:13:21 CDT