current user
SQL> desc user_role_privs;
 Name                                      Null?    Type
 —————————————– ——– —————
 USERNAME                                           VARCHAR2(30)
 GRANTED_ROLE                                       VARCHAR2(30)
 ADMIN_OPTION                                       VARCHAR2(3)
 DEFAULT_ROLE                                       VARCHAR2(3)
 OS_GRANTED                                         VARCHAR2(3)
by DBA user
SQL> desc dba_sys_privs
 Name                                      Null?    Type
 —————————————– ——– —————————
 GRANTEE                                   NOT NULL VARCHAR2(30)
 PRIVILEGE                                 NOT NULL VARCHAR2(40)
 ADMIN_OPTION                                       VARCHAR2(3)
 
 
1. sqlplus system/oracle@sox9i
Sqlplus > select privilege from dba_sys_privs where grantee=’OPWORKFLOW’;
2. sqlplus opworkflow/opworkflow@sox9i
Sqlplus> select granted_role from user_role_privs;