If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Find ORACLE_SID via SQL

All,

I've got a developer who wants to be able to find the ORACLE_SID via SQL, when connected to the database.
I've told him to look in V$instance or v$database,but the user he's using in his development won't have the access to those views. Do you have any idea where I can find the info for him with a 'normal' user?