Show what roles are granted to a user

Show what roles are granted to a user

select grantee
, granted_role
, admin_option
from dba_role_privs
where grantee like upper('&username')
/

Output:
Enter value for username: c40140
old   5: where  grantee like upper('&username')
new   5: where  grantee like upper('c40140')
GRANTEE                        GRANTED_ROLE                   ADM
------------------------------ ------------------------------ ---
C40140                         APPS_DEVELOPER                 NO
1 row selected.