List All Tables and Their Owners
The
iifile_info view (see page
Select File Names Associated with Tables) permits you to select all tables and their owners.
For example, the following query lists all user tables not owned by the DBA:
select tablename, table_owner, table_type
from iitables
where table_owner != '$INGRES' and
table_owner != 'DBA';