Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: V$SESSION who can access to this view
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