Privileges Utility function

This section describes the utility that lets you easily display, grant, and revoke Db2 privileges for various Db2 objects. When you revoke privileges, File-AID for Db2 shows only the privileges you can revoke. If you are a system administrator, you see all privileges.

Privileges - General

When you select option 6 from the Utility Selection Menu, the Privileges screen displays (see the following figure). Enter a number corresponding to the object type to which you will apply privileges and press Enter. You can only specify one object type at a time.

Privileges screen

A pop-up window displays based on the object type you selected. All pop-up windows show the three available options, but other information varies depending on the object type.

Privileges pop-up window sample

OPTION

Blank	Display the privileges assigned for an object.
G	Grant privileges for an object.
R	Revoke privileges for an object.

Other fields on these pop-ups vary based on the object type selected:

Object Type	Fields
Collection	Collection Name
Package	Collection Name Package Name
Plan	Plan Name
TABLE/VIEW/MQT/CLONE	Creator Name
Tablespace	Database Tablespace
Schema	Schema Name
Stored Procedure	Schema Name Procedure Name
Distinct Type	Schema Name Distinct Type Name Process Implied Cast Function If the option Process Implied Cast Function is set to Y, then after an action has been completed for privileges for a Distinct Type and PF3 is used to return, the same action will be taken for the implied cast function.
User Defined Function	Schema Name Function Name

If you enter an asterisk (*) or a pattern in any of the object type specific fields, a selection list displays (see the following figure).

Privilege Object Selection Screen

SEL

Type an S (select) beside the object for which you want to display, grant, revoke, or modify privileges. The system displays that object when you press Enter.

OBJECT

List of objects for selection.

TYPE

Indicates the object type. If you access this screen from a TABLE/VIEW/MQT/CLONE Privileges pop-up, both tables and views show under TYPE.

When you press Enter from the Privilege Object Selection screen, the Object Administration utility is displayed. For more information, see File-AID for Db2 Object Administration User Reference.