Note

Corresponding System Authorities: Privileges granted to either an SQL or external function or procedure are granted to its associated program (*PGM) or service program (*SRVPGM) object. Privileges granted to a Java(TM) external function or procedure are granted to the associated class file or jar file. If the associated program, service program, class file, or jar file is not found when the grant is executed, an error is returned.

GRANT and REVOKE statements assign and remove system authorities for SQL objects. The following table describes the system authorities that correspond to the SQL privileges:

Table 62. Privileges Granted to or Revoked from Non-Java Functions or Procedures
SQL Privilege Corresponding System Authorities when Granting to or Revoking from a Function or Procedure
ALL (Grant or revoke of ALL grants or revokes only those privileges the authorization ID of the statement has)
*OBJALTER
*OBJOPR
*EXECUTE
*OBJMGT (Revoke only)
ALTER *OBJALTER
EXECUTE
*EXECUTE
*OBJOPR
WITH GRANT OPTION *OBJMGT
Table 63. Privileges Granted to or Revoked from Java Functions or Procedures
SQL Privilege Corresponding Data Authorities when Granting to or Revoking from a Java Function or Procedure Corresponding Object Authorities when Granting to or Revoking from a Java Function or Procedure
ALL (Grant or revoke of ALL grants or revokes only those privileges the authorization ID of the statement has) *RWX
*OBJEXIST
*OBJALTER
*OBJMGT (Revoke only)
ALTER *R *OBJALTER
EXECUTE *RX
*EXECUTE
WITH GRANT OPTION *RWX *OBJMGT

Corresponding System Authorities When Checking Privileges to a Function or Procedure: The following table describes the system authorities that correspond to the SQL privileges when checking privileges to a function or procedure. The left column lists the SQL privilege. The right column lists the equivalent system authorities.

Table 64. Corresponding System Authorities When Checking Privileges to a Non-Java Function or Procedure
SQL Privilege Corresponding System Authorities
ALTER *OBJALTER
EXECUTE
*EXECUTE and *OBJOPR
Table 65. Corresponding System Authorities When Checking Privileges to a Java Function or Procedure
SQL Privilege Corresponding Data Authorities when Checking Privileges to a Java Function or Procedure Corresponding Object Authorities when Checking Privileges to a Java Function or Procedure
ALTER *R *OBJALTER
EXECUTE *RX
*EXECUTE

Syntax alternatives: The following keywords are synonyms supported for compatibility to prior releases. These keywords are non-standard and should not be used: