Re: Session# and SID In a Trigger

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 3 Oct 2002 06:49:12 -0700
Message-ID: <a20d28ee.0210030549.359e30c0@posting.google.com>

"B. Alfredo M. Naling, Jr." <someone_at_hotmail.com> wrote in message news:<angthm$m7r$1_at_reader01.singnet.com.sg>...
> How do I determine the session serial# and session sid inside a trigger. I
> know
> you can query v$session with a "where username = user" but I don't want this
> criteria as it is possible that one user is logged on more than once.
>
> Help!!!
>
> cheers,
> Alfredo

the correct criterion is
where audsid = userenv('sessionid')
This solution doesn't work for SYS.

Hth

Sybrand Bakker
Senior Oracle DBA Received on Thu Oct 03 2002 - 08:49:12 CDT