Re: What are the minimum privs needed to acces V$VERSION, OPTION, PARAMETER ?

Home -> Community -> Usenet -> c.d.o.misc -> Re: What are the minimum privs needed to acces V$VERSION, OPTION, PARAMETER ?

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 19 Jun 2002 10:30:16 +0100
Message-ID: <3d104f28$0$8511$ed9e5944@reading.news.pipex.net>

"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