Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: select on v$instance

Re: select on v$instance

From: Doug Cowles <dcowles_at_bigfoot.com>
Date: Wed, 03 Mar 1999 16:25:15 -0500
Message-ID: <36DDA8BB.9085CA88@bigfoot.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US