Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> select on v$instance
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?