8. Maintaining Databases : Viewing Database Objects : View Database Objects that Belong to Another User : List All Tables and Their Owners
 
Share this page                  
List All Tables and Their Owners
The iifile_info view (see 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';