Oracle Database Discussions

Hi

One of my user want to find the oracle service name through SQL query from user level. This user is not a DBA.

With DBA privs this querry

SELECT NAME, VALUE FROM V$PARAMETER WHERE NAME = 'service_names';

brings the correct result. But user he will not have the access to read the V$PARAMETER table which is part of sys object.

select sys_context('USERENV','SERVICE_NAME') from dual;

SYS_CONTEXT('USERENV','SERVICE_NAME')
--------------------------------------------------------------------------------
SYS$USERS

this query is not giving my the correct result. Is there any way we can grab the service name from user level.

Your cooperation is highly appreciated.

Rao