Corresponding System Authorities: 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 Package |
---|---|
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 |
Corresponding System Authorities When Checking Privileges to a Package: The following table describes the system authorities that correspond to the SQL privileges when checking privileges to a package. The left column lists the SQL privilege. The right column lists the equivalent system authorities.
SQL Privilege | Corresponding System Authorities When Checking Privileges to a Package |
---|---|
ALTER | *OBJALTER |
EXECUTE |
*EXECUTE and *OBJOPR |
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.