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

REVOKE Definition Privileges Parameters

DEFINE

Revokes the ALTER, CREATE, and DROP privileges on the resource identified in the ON parameter from the users or groups identified in the FROM parameter.

ALTER

Revokes the ALTER privilege on the resource identified in the ON parameter from the users or groups identified in the FROM parameter.

CREATE

Revokes the CREATE privilege on the resource identified in the ON parameter from the users or groups identified in the FROM parameter.

DISPLAY

Revokes the DISPLAY privilege on the resource identified in the ON parameter from the users or groups identified in the FROM parameter.

DROP

Revokes the DROP privilege on the resource identified in the ON parameter from the users or groups identified in the FROM parameter.

ON

Specifies the resource to which the definition privileges apply.

GROUP group-identifier

Identifies a group.

USER user-identifier

Identifies a user.

USER PROFILE profile-name

Identifies a user profile.

FROM

Specifies the users or groups from whom you are revoking definition privileges.

PUBLIC

Specifies all users.

authorization-identifier

Identifies a user or group.

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