Re: grant select on x$ table

On Jan 29, 12:54 pm, "Vladimir M. Zakharychev" <vladimir.zakharyc..._at_gmail.com> wrote:
> On Jan 29, 8:45 am, "Steve Robin" <ocma..._at_gmail.com> wrote:
>
> > please let me know how to give select priviledge on x$ tables. I am
> > try to give select on x$ktfbhc view to one of user. But I am getting
> > error :
>
> > SQL> grant select on x$ktfbhc to dbcheck;
> > grant select on x$ktfbhc to dbcheck
> > *
> > ERROR at line 1:
> > ORA-02030: can only select from fixed tables/viewsCan you provide a bit more detail on where you are trying to issue the
> grant and in which state the database is when you do it? Looks like
> the database is not open, or it's an ASM instance, which is not a
> database instance and thus you can't do anything in it but query its
> fixed views and tables related to ASM and manage disks/diskgroups.
>
> Hth,
> Vladimir M. Zakharychev
> N-Networks, makers of Dynamic PSP(tm)
> http://www.dynamicpsp.com

I am trying to give this priviledge from sys user. Received on Mon Jan 29 2007 - 03:03:32 CST