SELECT usr.username, usr.default_tablespace,
usr.temporary_tablespace "TMP TBS", usr.profile,
rl.granted_role, rl.admin_option, rl.default_role
FROM sys.dba_users usr, sys.dba_role_privs rl
WHERE usr.username = rl.grantee (+)
GROUP BY usr.username, usr.default_tablespace,
usr.temporary_tablespace, usr.profile,
rl.granted_role, rl.admin_option, rl.default_role;