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 60. Privileges Granted to or Revoked from Distinct Types
SQL Privilege Corresponding System Authorities when Granting to or Revoking from a Distinct Type
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
USAGE
*EXECUTE
*OBJOPR
WITH GRANT OPTION *OBJMGT

Corresponding System Authorities When Checking Privileges to a Distinct Type: The following table describes the system authorities that correspond to the SQL privileges when checking privileges to a distinct type. The left column lists the SQL privilege. The right column lists the equivalent system authorities.

Table 61. Corresponding System Authorities When Checking Privileges to a Distinct Type
SQL Privilege Corresponding System Authorities when Granting to or Revoking from a Distinct Type
ALTER *OBJALTER
USAGE
*EXECUTE and *OBJOPR

When USAGE privilege is required: USAGE privilege is required when a distinct type is explicitly referenced in an SQL statement. For example, in a statement that contains a CAST specification or in a CREATE TABLE statement. The USAGE privilege is not required when a distinct type is indirectly referenced. For example, when a view references a column of a table that has a distinct data type.

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