Syntax for Securing Database Resources › GRANT Access Module Execution Privilege › GRANT Access Module Execution Privilege Parameters

GRANT Access Module Execution Privilege Parameters

ON ACCESS MODULE access-module-name

Identifies the access module to which the EXECUTE privilege applies.

You can wildcard access-module-name. If you specify schema-name, the wildcard character is valid after the period following schema-name.

Note: For more information, see Using a Wildcard.

schema-name

Identifies the schema associated with access-module-name.

If you do not specify schema-name, it defaults to the current schema in effect for your session.

Note: For more information about using a schema name to qualify an access module name, see the CA IDMS SQL Reference Guide.

TO

Identifies the users or groups to whom you are giving EXECUTE privilege.

PUBLIC

Specifies all users.

authorization-identifier

Identifies a user or group.

WITH GRANT OPTION

Gives the privilege of granting EXECUTE privilege on the named access module to the users identified in the TO parameter.

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