Re: select on v$instance

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 Feb 24 1999 - 15:58:43 CST