Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: select on v$instance
My mistake I meant v$database, so v_$database works fine.
Let's say I wanted to grant access to all v$ views. How can
I get a list of all of the v_ tables? They don't seem to be in dba_tables,
and the views don't appear in dba_views. I'm connected as SYS.
Where should I be looking?
Thanks in advance,
Dc.
Jonathan Lewis wrote:
> connect sys/{password}
> grant select on v_$instance to {user};
>
> This doesn't show them the schema they are in, though.
>
> Jonathan Lewis
> Yet another Oracle-related web site: www.jlcomp.demon.co.uk
>
> Doug Cowles wrote in message <36D47342.AF72E78A_at_bigfoot.com>...
> >I want to grant privileges to select on v$instance to a few users so
> >they can be absolutely sure what schema they are in. I don't want to
> >grant select any table to allow this to happen, nor do I want them to be
> >able to look at every v$ view, just that one. How
> >can I do this?
> >
> >- Dc.
> >
Received on Wed Mar 03 1999 - 15:25:15 CST