Note

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:

Table 66. Privileges Granted to or Revoked from Packages
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.

Table 67. Corresponding System Authorities When Checking Privileges to a Package
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: