Re: how to find session id/serial no. of current session

Thomas Kyte wrote:
>
> On Sun, 5 Oct 1997 01:04:35 +0800, "S S Wan" <sswan_at_hk.super.net> wrote:
>
> >Does anybody know how to find the session id and serial number
> >of the current session?
> >
> >Thanks.
> >
>
> select sid, serial# from v$session where audsid = userenv('sessionid');
>
> will do it....
>

It will only for a user having SELECT ANY TABLE privilege. That's exactly the problem...

-- 
Martin Haltmayer