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;