Try this

SELECT username,
account_status,
default_tablespace,
temporary_tablespace,
profile,
granted_role,
admin_option,
default_role
FROM sys.dba_users a, sys.dba_role_privs b
WHERE a.username = b.grantee
ORDER BY username,
account_status,
default_tablespace,
temporary_tablespace,
profile,
granted_role
/