Using the Manage Db2® Privileges panel

Location

Leave this field blank if the objects you want listed are at your current location. Otherwise, type the full name of the remote location, an asterisk (*) to display all available remote locations, or a pattern using wildcard characters. If you specify an asterisk on its own or a pattern, FM/Db2 displays a selection list showing the locations that match the input specification.

To select the location you want, type S against the required entry and press Enter.

Note: You can only specify a location if displaying privileges (command line blank).

Owner

To select objects regardless of their owner, leave this field blank. Otherwise, to restrict the list of objects by owner, type either the full name of the owner or a pattern using wildcard characters. If this entry field is not blank, FM/Db2 limits the objects listed to those matching the owner selection criteria you specify.

Note: You can only specify an owner for table or column object types.

Name

To select objects regardless of their name, leave this field blank. Otherwise, to restrict the list of objects by name, type either the full name of the object or a pattern using wildcard characters. If this entry field is not blank, FM/Db2 limits the objects listed to those matching the name selection criteria you specify.

In

This is an optional field you can use to qualify the following object types:

Object type	Qualify by specifying the…
Table space	Name of the database
Column	Name of the table
Package	Name of the collection
Distinct type	Name of the schema
Function	Name of the schema
Stored procedure	Name of the schema

To select the object type you want, type the appropriate number in the Object Type selection field. The default value is 3 (table).