Show what system privileges are granted to a role

Show what system privileges are granted to a role

select privilege
, admin_option
from role_sys_privs
where role like '&role'
/

Output:

SQL> select     privilege, admin_option
from    role_sys_privs
where   role like '&role'
/
  2    3    4    5  Enter value for role: RESOURCE
old   4: where  role like '&role'
new   4: where  role like 'RESOURCE'

PRIVILEGE                                ADM
---------------------------------------- ---
CREATE TRIGGER                           NO
CREATE SEQUENCE                          NO
CREATE CLUSTER                           NO
CREATE TYPE                              NO
CREATE PROCEDURE                         NO
CREATE TABLE                             NO
CREATE INDEXTYPE                         NO
CREATE OPERATOR                          NO

8 rows selected.