DBA FUS‎ > ‎

Tablespace Quotas

posted Sep 13, 2010, 6:09 AM by Sachchida Ojha
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');
Comments