Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: V$SESSION who can access to this view

Re: V$SESSION who can access to this view

From: Terry Dykstra <tdykstra_at_cfol.ab.ca>
Date: Fri, 14 Jan 2000 15:57:44 GMT
Message-ID: <YHHf4.90897$n3.1466714@news0.telusplanet.net>


You need to do the grant on the underlying table v_$session.

--
Terry Dykstra
Canadian Forest Oil Ltd.
Check out Sybase Developer's Network: http://www.sybase.com/sdn

Nicolas Bronke <newsgroup_at_trinity.de> wrote in message news:387f3ce9_3_at_news2.prserv.net...
> Which privileges are necessary to perform a select * from v$session.
>
> I would like to grant this rights someone without DBA-rights
>
> I tried to perform a grant select using the SYSTEM user. But system does
not
> have enough rights.
> I tried to perform a grant select using the SYS user. I got the error
> message that this is not possible!
>
> Does exist a possibility on Oracle 8.0.5?
>
>
> --
> Regards
> Nicolas Bronke
>
>
Received on Fri Jan 14 2000 - 09:57:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US