select granted_role from dba_roles where grantee = 'YOUR_USER' where default_role='YES';