hi all
i have a question about Oracle Roles
i was reading the below doc
http://psoug.org/reference/roles.html
my question is
e,g
SQL> create role olap_role;
Role created.
SQL> grant connect,resource to olap_role;
Grant succeeded.
SQL> select role, GRANTED_ROLE from role_role_privs;
this is what i did.
connect and resource as oracle standard. if someone has changed the roles inside connect and resource, from which table can I get the information
SQL> select role, GRANTED_ROLE from role_role_privs;
ROLE GRANTED_ROLE
------------------------------ ------------------------------
DBA SCHEDULER_ADMIN
DBA OLAP_DBA
DBA EXECUTE_CATALOG_ROLE
DBA DELETE_CATALOG_ROLE
JAVASYSPRIV JAVAUSERPRIV
XDBADMIN XDBWEBSERVICES
OLAP_USER SELECT_CATALOG_ROLE
IMP_FULL_DATABASE EXECUTE_CATALOG_ROLE
LOGSTDBY_ADMINISTRATOR RESOURCE
OLAP_ROLE CONNECT
DBA SELECT_CATALOG_ROLE
ROLE GRANTED_ROLE
------------------------------ ------------------------------
DBA EXP_FULL_DATABASE
DBA WM_ADMIN_ROLE
EXP_FULL_DATABASE EXECUTE_CATALOG_ROLE
IMP_FULL_DATABASE SELECT_CATALOG_ROLE
OLAP_DBA SELECT_CATALOG_ROLE
DBA GATHER_SYSTEM_STATISTICS
DBA JAVA_DEPLOY
EXECUTE_CATALOG_ROLE HS_ADMIN_ROLE
EXP_FULL_DATABASE SELECT_CATALOG_ROLE
OLAP_USER CONNECT
OLAP_ROLE RESOURCE
ROLE GRANTED_ROLE
------------------------------ ------------------------------
DBA JAVA_ADMIN
DBA IMP_FULL_DATABASE
DBA XDBADMIN
SELECT_CATALOG_ROLE HS_ADMIN_ROLE
DBA XDBWEBSERVICES
OLAP_USER RESOURCE
OLAP_USER OEM_MONITOR
29 rows selected.
there is nothing called resource in the roles column. I know i am missing something. but i am unable to get it.