Re: find out who makes the update in a trigger event

From: Mario <mtechera_at_wpmc.com>
Date: Fri, 18 May 2001 01:32:52 +0200
Message-ID: <9e1mv3$chk$1@news.online.de>

Steno,

look at the USERENV function in the SQL Manual

Mario

"steno" <snovotny_at_integro.net> wrote in message news:9e0619$bhnt$1_at_ID-37725.news.dfncis.de...
> hi there,
>
> i want to log database changes trough triggers.
> therefore i need to know which session fires the trigger. is there a
> possibilty to get the SID from the session which fired the trigger?
>
> additionally i added triggers on v$session to recognize if there is a new
> session
> and capture the commit and rollback command.
>
> thanks in advance
> steno
>
>
>
>
Received on Thu May 17 2001 - 18:32:52 CDT