Re: Identifying session (7.1.6)

Veijo Länsikunnas wrote:
>
> Hello,
>
> Does anybody have ideas how to identify the current session?
> I have a need to occationally know the name of the OS-user of
> the current session, and I haven' found out any way to do this.
> Any idea?
>
> //Veijo

select * from v$session where audsid = userenv('SESSIONID');

should do the trick.

Hope this helps,

John Hough Received on Thu Mar 06 1997 - 00:00:00 CST