select GRANTEE, GRANTED_ROLE, DEFAULT_ROLE from dba_role_privs where GRANTEE ='&Grantee';
Sample Output:
Code: Select all
GRANTEE GRANTED_ROLE DEF
------------------------------ ------------------------------ ---
SCOTT RESOURCE YES
SCOTT CONNECT YES