Hello Oracle Experts,
Now I am using 11.2
According to Oracle SQL 11.2 Doc,
SELECT role FROM session_roles;
ROLE
--------
RESOURCE
SELECT SYS_CONTEXT('SYS_SESSION_ROLES', 'RESOURCE')
FROM DUAL
SYS_CONTEXT('SYS_SESSION_ROLES','RESOURCE')
--------------------------------------
TRUE
SELECT SYS_CONTEXT('SYS_SESSION_ROLES', 'DBA')
FROM DUAL;
SYS_CONTEXT('SYS_SESSION_ROLES','DBA')
--------------------------------------
FALSE
But I am getting these below responses as null.
SELECT role FROM session_roles;
ROLE
------------------------------
SELECT_CATALOG_ROLE
HS_ADMIN_SELECT_ROLE
EXECUTE_CATALOG_ROLE
HS_ADMIN_EXECUTE_ROLE
XDBADMIN
SELECT SYS_CONTEXT('SYS_SESSION_ROLES', 'SELECT_CATALOG_ROLE')
FROM DUAL;
SYS_CONTEXT('SYS_SESSION_ROLES','SELECT_CATALOG_ROLE')
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SELECT SYS_CONTEXT('SYS_SESSION_ROLES', 'HS_ADMIN_SELECT_ROLE')
FROM DUAL;
SYS_CONTEXT('SYS_SESSION_ROLES','HS_ADMIN_SELECT_ROLE')
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
please help me.
goutam