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.
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.