Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: select on v$instance
v_$database, my mistake..I meant what database they were in since
they have identical user names on several different database.
What if though, I want to grant select on all the v$ views, without select
any table. I connected as sys, and looked in dba_tables, and couldn't find
and v_..... tables, and I couldn't find any v$.... views in dba_views. Am
I doing something wrong?
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:28:32 CST