Query User Details

You can query dba_users view to get user relevant data of your Oracle database.

Eg:

SELECT * FROM DBA_USERS
WHERE DEFAULT_TABLESPACE IN ('TBS1','TBS2')
ORDER BY DEFAULT_TABLESPACE,USERNAME