Xref: alice comp.databases.oracle.server:42381
Path: alice!news-feed.fnsi.net!dca1-hub1.news.digex.net!digex!howland.erols.net!portc02.blue.aol.com!nyd.news.ans.net!abq.news.ans.net!news.chips.ibm.com!newsfeed.btv.ibm.com!rtpnews.raleigh.ibm.com!ausnews.austin.ibm.com!not-for-mail
From: Doug Cowles <dcowles@bigfoot.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: select on v$instance
Date: Wed, 03 Mar 1999 16:11:20 -0500
Organization: IBM Austin 
Lines: 30
Message-ID: <36DDA578.27163B24@bigfoot.com>
References: <36D47342.AF72E78A@bigfoot.com> <919893537.13334.0.nnrp-02.9e984b29@news.demon.co.uk>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 4.04 [en] (Win95; U)
To: Jonathan Lewis <jonathan@jlcomp.demon.co.uk>

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@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.
> >