Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: What are the minimum privs needed to acces V$VERSION, OPTION, PARAMETER ?
"Toto" <laly.kattoor_at_freesbee.fr> wrote in message
news:2002619-10557-311819_at_foorum.com...
>
> Hi,
>
> I think you can just grant select on those views :
> grant select on V$SESSION to ...
The problem is that v$session isn't a view but a synonym for a view. You need to grant on the underlying objects.
>
> I cannot try, since I don't have enought rights.
>
> I cannot understand what you mean by 'since they are not fixed'.
They are special views that give access to memory and other structures, not conventional tables.
>
> Bye.
>
> --
> Use our news server 'news.foorum.com' from anywhere.
> More details at: http://nnrpinfo.go.foorum.com/
Received on Wed Jun 19 2002 - 04:30:16 CDT
![]() |
![]() |