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 -> select on v$instance

select on v$instance

From: Doug Cowles <dcowles_at_bigfoot.com>
Date: Wed, 24 Feb 1999 16:46:42 -0500
Message-ID: <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?

Received on Wed Feb 24 1999 - 15:46:42 CST

Original text of this message

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