Re: grant select on dba_ and v$ views to an user.

The v$ prefixed names are synonyms for v_$ prefixed views. So instead of v$session you need to use v_$session in your grant

Hth,

Sybrand Bakker, Oracle DBA

"Chris Lee" <clee_at_innocent.com> wrote in message news:3A605F4B.BD81CB8E_at_innocent.com...
> Hi,
>
> I need to grant "select" on some of the v$ and dba_ views to an user. I
> was able to do so with the the dba_ views, but I got errors with v$
> views. This is what I got:
>
> >>>>>
> SQL> connect internal
> Connected.
> SQL> grant select on dba_tablespaces to clee;
>
> Grant succeeded.
>
> SQL> grant select on v$session to clee;
> grant select on v$session to clee
> *
> ERROR at line 1:
> ORA-02030: can only select from fixed tables/views
> <<<<<
>
> Is there any way that I can grant "select" on v$ views to an user?
>
> Thanks in advance,
>
> -- Chris
Received on Sat Jan 13 2001 - 10:40:55 CST