How to get SID from dual

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

select * from global_name;

This should work.

Badirnath

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?

Code:

---


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

---

Sam

Thanks Sam.