How to get SID from dual

[sureshot]

How to get SID from dual if user does not have SELECT_CATALOG_ROLE.
He can not see v$ tables.

[badrinathn]

select * from global_name;

This should work.

Badirnath

[sureshot]

Badri... Thanks...

Global is often manually updated and it could be pointing to a wrong value if the database is cloned from another database.

If there a USERENV or SYS_CONTEXT command we can do to get SID from dual?

[sambavan]

         SELECT SYS_CONTEXT('USERENV','DB_NAME') FROM dual;

Sam

[sureshot]

Thanks Sam.