DB2 graphic  QMF Version 8

Check table authorizations

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.

Fields

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.

Procedure

  1. Select the Check for tables with no authorizations option.
  2. Click Next.

    The Grant Table Authorizations dialog box opens if unassigned tables are found.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004