Hi,

------------------------------------------
select sid, username
from v$session
where audsid = userenv('sessionid');
------------------------------------------


Have you tried putting this SQL in a DB trigger? I tried but I am getting some errors. I am tring to get the session id of user who fired the trigger(update or delete a table). Is this possible?