DB2 graphic  QMF Version 8

Permissions

After you bind the QMF for Windows packages, you must grant permission to users to execute the packages. Use the Permissions page of the Packages wizard to grant or revoke permission to the user IDs of QMF for Windows and QMF for WebSphere users, specifying what packages they can run on the database server. You can grant or revoke permission to all user IDs, or to specific IDs.

Note:
The Permissions procedure grants the authority required to execute the packages contained within a collection. QMF for Windows creates the collection containing these packages on the iSeries with authority PUBLIC * EXCLUDE. Grant the appropriate authority for users of that collection and library on the iSeries.

Fields

User IDs

Type the user IDs of the users who will be granted permission to run QMF for Windows on the database server. Alternatively, type the user IDs for whom permission to run QMF for Windows on this database will be revoked.

To grant or revoke permission for all users, select the default ID PUBLIC. QMF for Windows stores valid user IDs for the database server in the User ID table.

Procedure

  1. Type the user IDs for which you are granting authority to the packages.
  2. Click Grant to give the user IDs permission at the server.

    The following message is issued after permission is granted:

    Permission to execute the user packages has been granted to the
    specified user IDs.
  3. Optional: Type the user ID and click Revoke to prohibit the user IDs from running queries at the database server.
  4. Click Finish.
  5. Optional: The Check Table Authorizations page opens next if you selected the following option at the Object Listing Option page:
    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.

Controls

Table 15. Permissions Controls
Control Description
Grant Grant the selected user IDs permission to run QMF for Windows on the database server
Note:
If you use the default user ID (PUBLIC), to grant all QMF for Windows users permission to run queries on the database server, you need to grant permission to the PUBLIC user ID by selecting the ID and clicking Grant.
Revoke Prohibit the selected user IDs from running QMF for Windows queries at the database server
Back Close the Permissions page of the Packages wizard and open the Bind Packages page
Finish Complete processing of the Packages wizard and open the Catalog page
Cancel Close the Permissions page of the Packages wizard; no information is saved
Help View online help for this page


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