Re: select on v$instance

From: Alex J <Alexjent_at_prodigy.net>
Date: Thu, 25 Feb 1999 19:06:08 -0600
Message-ID: <7b4s4k$e4gm$1@newssvr04-int.news.prodigy.com>

You could also create a stored procedure that simply returns whatever is required.

Alex

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 Thu Feb 25 1999 - 19:06:08 CST