Using the Manage Db2® Privileges panel

The Manage Db2® Privileges panel consists of two sections:
Object Identification Criteria
Use this section of the panel to specify object identification criteria to identify the objects you want listed. FM/Db2 lists all objects, restricted by any such criteria, for which privileges exist. Input in this section depends on the Object Type you specify.
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
Object Type
Use this section to identify the type of Db2® object against which privilege operations are performed. The available functions for managing Db2® privileges are shown in Privilege functions.

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

You select whether to display, grant, or revoke privileges by what, if anything, you type on the command line:
Display privileges
To select this processing option, leave the command line blank.
Grant privileges
To select this processing option, type G on the command line.
Revoke privileges
To select this processing option, type R on the command line.
Note: To change an existing privilege, you must:
  1. Revoke the existing privilege.
  2. Grant the new privilege.

Related tasks

Related references