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.
Got the answer :
SELECT * FROM DBA_ROLES;
1.4m articles
1.4m replys
5 comments
57.0k users