Use the Check Table Authorizations page to specify whether to check for tables that exist on the database server without authorizations.
This page opens if you selected the following option at the Object Listing Option page, and tables without authorizations were found at the database server after the QMF for Windows packages were bound:
Include only those objects that any of the user's primary or secondary authorization IDs are authorized to access. This option requires the most database resources when producing lists.
Tables that are missing permissions are not visible to QMF for Windows and do not appear in table lists. There must be at least one authorization on each table, recorded in the authorizations catalog table. Some tables can exist without authorizations and will not cause errors. However, these tables do not appear in table lists. QMF for Windows can detect and correct the authorization status by granting privilege on the tables to the specified user ID.
You need to check for tables with no permissions after you bind the packages and assign permissions.
Do not check for tables with no authorizations
Select this option to specify that QMF for Windows will not check for tables that are missing authorizations on the database server.
Check for tables with no authorizations
Select this option to specify that QMF for Windows will check the database server for tables that do not have authorizations. QMF for Windows searches the database server after the packages are bound for tables that do not have authorizations. If tables are found, the Grant Table Authorizations page opens; use this page to specify a user ID that will be used to grant authorization to the table.
The Grant Table Authorizations dialog box opens if unassigned tables are found.