SQL> --Lists the roles that have been granted to the user
SQL>
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)
SQL>
SQL> select * from USER_ROLE_PRIVS where rownum < 200;
USERNAME GRANTED_ROLE ADM DEF OS_
------------------------------ ------------------------------ --- --- ---
RNTSOFT DBA NO YES NO
SQL>
SQL>