Question

How to list all the roles existing in Oracle database?

I have been searching in the tables :

ROLE_TAB_PRIVS
ROLE_SYS_PRIVS
ROLE_ROLE_PRIVS

SELECT * FROM ROLE_TAB_PRIVS WHERE ROLE = 'ROLETEST';

but I can't find a role that I have just created.

question from:https://stackoverflow.com/questions/20725581/how-to-list-all-the-roles-existing-in-oracle-database

Answer 1

Got the answer :

SELECT * FROM DBA_ROLES;