Was this helpful?
View Database Objects that Belong to Another User
To view and work with database objects belonging to another user, you must impersonate that user (which requires the security privilege).
To impersonate another user, select that user from the Users branch in the Virtual Nodes window in VDBA and open a Database Object Manager window. The objects belonging to that user and those belonging to the DBA appear in the window, where you can view and manage them.
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 table_name, table_owner, table_type
  from iitables
  where table_owner != '$INGRES' and
  table_owner != 'DBA';
Last modified date: 11/09/2022