You can use this to know the instance:
select user||'@'||global_name
from global_name;
Prakash
Alex J wrote in message <7b4s4k$e4gm$1_at_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 Sun Feb 28 1999 - 13:01:38 CST
