Re: Process Id

likely anyone with select_catalog_role but essentially Volker is correct. I
*think* (read can't be bothered to work out) that select @@spid is
restricted to dbo, or folk with read access to master as well. If it isn't
it ought to be.


--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"DJ" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>
> "Volker Hetzer" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
> >
> > "Niall Litchfield" <[EMAIL PROTECTED]> schrieb im
> Newsbeitrag
> > news:[EMAIL PROTECTED]
> > > http://www.jlcomp.demon.co.uk/faq/MySessID.html
> > >
> > But only sys can access v$session.
> >
> > Greetings!
> > Volker
> >
>
> unless you grant access to it?
>
>