Security: Find out users quota for tablespaces

Query dba_ts_quotas to see users' quota per tablespace

SQL> select tablespace_name from dba_ts_quotas where username = 'USERNAME'