Re: select on v$instance

In article <36DED6E3.232438AE_at_bigfoot.com>,   Doug Cowles <dcowles_at_bigfoot.com> wrote:
> I meant v_$database, which works ok. How do I get a list of all of the
> views?
> Connected as sys, I don't get any v_$...tables, and I don't get any v$etc.,
> from
> dba_Views. What am I doing wrong?
>
> - 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.
> > >
>

Look in v$fixed_table for a list of all the v$ and x$ tables. Note that the v$ tables are actually synonyms to the v_$ views which is why you did not locate it with your search.

Mark D. Powell -- The only advice that counts is the advice that  you follow so follow your own advice --

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Mar 05 1999 - 08:22:24 CST