How to get all privileges assigned to a particular role
I tried
SELECT ROLE, PRIVILEGE FROM ROLE_SYS_PRIVS WHERE ROLE='ROLE1';
SELECT ROLE, GRANTED_ROLE FROM ROLE_ROLE_PRIVS WHERE ROLE='ROLE1';
SELECT ROLE, TABLE_NAME, PRIVILEGE FROM ROLE_TAB_PRIVS;
but neither returned any rows. Am I missing anything or the role really does not have any privileges assigned to it?