Previous Topic Next topic Print topic

Micro Focus Studio Enterprise Edition for Windows > Programming > Mainframe Programming > SQL Option for DB2 > Reference > XDB Directive Options > GRANT-EXECUTE

GRANT-EXECUTE

Syntax:

GRANT-EXECUTE={PUBLIC | NONE |(authorization-ID)}

Parameters:

PUBLIC Grants execute privileges on the package to public.
NONE No execute privileges granted.
authorization-ID Grants execute privileges to the given authorization ID, which must be a valid authorization ID defined via SQL Wizard.

Properties:

Default: PUBLIC

Comments:

  • This directive has meaning only when the program has been statically bound.
  • If you do not specify this directive, execute privileges on the package are automatically granted to PUBLIC.
  • To disable this directive, specify GRANT-EXECUTE=NONE.
Parent topic: XDB Directive Options
Previous Topic Next topic Print topic