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?

Thanks ,

Rik