This form of the GRANT statement grants privileges on a type.
This statement can be embedded in an application program or issued interactively. It is an executable statement that can be dynamically prepared.
The privileges held by the authorization ID of the statement must include at least one of the following:
For each distinct type or array type identified in
the statement: 
If WITH GRANT OPTION is specified, the privileges held by the authorization ID of the statement must include at least one of the following:
.-PRIVILEGES-. >>-GRANT--+-ALL--+------------+-+-------------------------------> | .-,---------. | | V | | '---+-ALTER-+-+-------' '-USAGE-' .-,----------------------. V | >--ON -TYPE----+-distinct-type-name-+-+-------------------------> '-array-type-name----' .-,----------------------. V | >--TO----+-authorization-name-+-+--+-------------------+------->< '-PUBLIC-------------' '-WITH GRANT OPTION-'
Grants one or more
privileges. The privileges granted are all those grantable privileges
that the authorization ID of the statement has on the specified distinct
types or array types. Note that granting ALL PRIVILEGES on a type
is not the same as granting the system authority of *ALL. If you do not use ALL, you must use one or more of the keywords listed below. Each keyword grants the privilege described.

and LABEL
statement.
Identifies the distinct types or
array types on which the privilege is granted. The distinct-type-name or array-type-name must
identify a user-defined type that exists at the current server.
If WITH GRANT OPTION is omitted, the specified authorization-names cannot grant the USAGE privilege to others unless they have received that authority from some other source (for example, from a grant of the system authority *OBJMGT).
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 User-defined Type |
|---|---|
| ALL (Grant or revoke of ALL grants or revokes only those privileges the authorization ID of the statement has) | *OBJALTER |
| ALTER | *OBJALTER |
| USAGE | *EXECUTE |
| WITH GRANT OPTION | *OBJMGT |
Corresponding System Authorities When Checking Privileges to a User-defined Type: The following table describes the system authorities that correspond to the SQL privileges when checking privileges to a type. The left column lists the SQL privilege. The right column lists the equivalent system authorities.
| SQL Privilege | Corresponding System Authorities when Granting to or Revoking from a User-defined Type |
|---|---|
| ALTER | *OBJALTER |
| USAGE | *EXECUTE and *OBJOPR |
When USAGE privilege is required: USAGE privilege is required when a 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 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:
Grant the USAGE privilege on distinct type SHOE_SIZE to user JONES. This GRANT statement does not give JONES the privilege to execute the cast functions that are associated with the distinct type SHOE_SIZE.
GRANT USAGE ON DISTINCT TYPE SHOE_SIZE TO JONES