User and Role what priviliges have assign

What Role does user have in current running session

SQL> show user

USER is "VISION211"

SQL> select * from session_roles;

ROLE

------------------------------

CONNECT

RESOURCE

What Role does user have and with admin option or not

SQL> show user

USER is "VISION211"

SQL> select * from user_role_privs;

USERNAME                       GRANTED_ROLE                   ADM DEF OS_

------------------------------ ------------------------------           --- --- ---

VISION211                      CONNECT                                   NO  YES NO

VISION211                      RESOURCE                                  NO  YES NO

What System Privileges does ROLE have and with admin option or not

SQL> desc role_sys_privs

 Name                                      Null?    Type

 ----------------------------------------- -------- ----------------------------

 ROLE                                      NOT NULL VARCHAR2(30)

 PRIVILEGE                                 NOT NULL VARCHAR2(40)

 ADMIN_OPTION                                       VARCHAR2(3)

SQL> select PRIVILEGE, ADMIN_OPTION from role_sys_privs where role='RESOURCE';

PRIVILEGE                                ADM

---------------------------------------- ---

CREATE SEQUENCE                       NO

CREATE TRIGGER                           NO

CREATE CLUSTER                           NO

CREATE PROCEDURE                     NO

CREATE TYPE                              NO

FORCE TRANSACTION               NO

CREATE VIEW                              NO

CREATE OPERATOR                    NO

CREATE TABLE                             NO

CREATE INDEXTYPE                    NO