-
I need to recover the name of the computer and the login name when a user makes an update to a table in a trigger
when I try to recover the USERENV('TERMINAL') it gave me the table name but I can not see who is the person that used the trigger
there is any way to get the information?
I apreciate your help
Thanks for your help
[Edited by lmarinve on 03-06-2002 at 06:34 AM]
-
From Kris109
SELECT SYS_CONTEXT ('USERENV', 'HOST') FROM DUAL;
see also : http://dbasupport.com/forums/showthr...threadid=21948