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:
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 |
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.
SQL Privilege | Corresponding System Authorities |
---|---|
ALTER | *OBJALTER |
EXECUTE |
*EXECUTE and *OBJOPR |
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:
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.