Checking System Privileges Granted to a Role : Roles « User Privilege « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. User Privilege
3. Roles

You can check which system privileges have been granted to a role by querying role_sys_privs.

SQL> desc role_sys_privs;
 Name               Null?    Type
 ROLE               NOT NULL VARCHAR2(30) --Name of the role.
 PRIVILEGE          NOT NULL VARCHAR2(40) --System privilege granted to the role.
 ADMIN_OPTION       VARCHAR2(3)           --Whether the privilege was granted with the ADMIN option. Equal to YES or NO.


SELECT *
FROM role_sys_privs;