DB2 graphic  QMF Version 8

Specifying options for listing objects

Use the Object Listing Option window to specify the level of filtering that will apply when producing lists of objects for QMF for Windows users.

Fields

Include all objects without respect to whether the user is authorized to access them

Check this check box to have all database objects from the database server's system table SYSTBLS included in a list requested by a QMF for Windows user regardless of their primary user ID.

This option uses the smallest amount of database resources when producing lists. However, lists will include some objects that are irrelevant and unaccessible to the user. In some cases, lists can be quite large.

Include only those objects that the user's primary or current authorization ID is allowed to access

Check this check box to filter the database objects that are included in a list that a user requests. Only those database objects from the database server's system table SYSTBLS that the user can access using their primary user ID or a current authorization ID are included in the list.

This option uses more database resources but results in more manageable and meaningful lists for the user.

Include objects that the user's primary or secondary IDs are allowed to access

Check this check box to filter the database objects that are included in a list that a user requests to include all the objects from the database server's system table SYSTBLS that the user can access using their primary user ID, their current authorization ID, and any other authorization ID that is associated with their primary ID.

This option requires the most database resources when producing lists but it produces the most extensive list of a user's database objects.

Note:
QMF for Windows uses the current SQL ID as the current authorization ID. All other authorization IDs that a user might have access to are defined outside of QMF for Windows. If you check this check box, you must edit the QMF for Windows RDBI.AUTHID_TABLE table to includes all the authorization IDs.


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