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" <nospamplease_at_goaway.com> wrote in message
news:cTNyb.3276$Hy3.887_at_newsfep4-winn.server.ntli.net...
>
> "Volker Hetzer" <volker.hetzer_at_ieee.org> wrote in message
> news:bqfqhu$pgj$1_at_news.fujitsu-siemens.com...
> >
> > "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> schrieb im
> Newsbeitrag
> > news:3fcb6be3$0$13350$ed9e5944_at_reading.news.pipex.net...
> > > http://www.jlcomp.demon.co.uk/faq/MySessID.html
> > >
> > But only sys can access v$session.
> >
> > Greetings!
> > Volker
> >
>
> unless you grant access to it?
>
>
Received on Mon Dec 01 2003 - 15:55:33 CST
