Syntax for Securing Global Resources › GRANT Definition Privileges › GRANT Definition Privileges Parameters

GRANT Definition Privileges Parameters

DEFINE

Gives the ALTER, CREATE, and DROP privileges on the resource identified in the ON parameter to the users or groups identified in the TO parameter.

ALTER

Gives the ALTER privilege on the resource identified in the ON parameter to the users or groups identified in the TO parameter.

The ALTER privilege on a resource allows the user to modify the resource definition.

CREATE

Gives the CREATE privilege on the resource identified in the ON parameter to the users or groups identified in the TO parameter.

The CREATE privilege on a resource allows the user to define the resource.

DISPLAY

Gives the DISPLAY privilege on the resource identified in the ON parameter to the users or groups identified in the TO parameter.

The DISPLAY privilege allows the user to issue a DISPLAY RESOURCE statement on the named resource. The grantable DISPLAY privilege allows a user to issue a DISPLAY PRIVILEGES statement on the named resource.

DROP

Gives the DROP privilege on the resource identified in the ON parameter to the users or groups identified in the TO parameter.

The DROP privilege on a resource allows the user to delete the definition of the resource.

ON

Specifies the resource to which the specified definition privileges apply.

GROUP group-identifier

Identifies a group.

You can wildcard group-identifier.

Note: For more information, see Using a Wildcard.

USER user-identifier

Identifies a user.

You can wildcard user-identifier.

Note: For more information, see Using a Wildcard.

USER PROFILE profile-name

Identifies a user profile.

You can wildcard profile-name.

Note: For more information, see Using a Wildcard.

TO

Specifies the users to whom you are giving definition privileges.

PUBLIC

Specifies all users.

authorization-identifier

Identifies a user or group.

Note: Expanded syntax for authorization-identifier is presented in the chapter Notes on Security Statement Syntax.

WITH GRANT OPTION

Gives the privilege of granting the specified definition privileges to the users or groups identified in the TO parameter.

A privilege granted with the WITH GRANT OPTION is called a grantable privilege.