Check for Tablespace Quotas

Select username,tablespace_name
from dba_ts_quotas
where username not in (select distinct owner from dba_objects)
and username not in (select grantee from dba_role_privs where granted_role='DBA');