This form of the REVOKE statement removes the 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: 
.-PRIVILEGES-. >>-REVOKE--+-ALL--+------------+-+------------------------------> | .-,---------. | | V | | '---+-ALTER-+-+-------' '-USAGE-' .-,----------------------. V | >--ON -TYPE----+-distinct-type-name-+-+-------------------------> '-array-type-name----' .-,----------------------. V | >--FROM----+-authorization-name-+-+---------------------------->< '-PUBLIC-------------'
Revokes one or
more type privileges from each authorization-name. The privileges
revoked are those privileges on the identified user-defined types
that were granted to the authorization-names. Note that revoking
ALL PRIVILEGES on a type is not the same as revoking the system authority
of *ALL. If you do not use ALL, you must use one or more of the keywords listed below. Each keyword revokes the privilege described.

Revokes the privilege
to use the COMMENT and LABEL statements.
Revokes the privilege to use user-defined
types in tables, functions, procedures, or as the source type in a
CREATE TYPE statement.
Identifies
the distinct type from which the privilege is revoked. The distinct-type-name or array-type-name must
identify a user-defined type that exists at the current server.
Multiple grants: If authorization ID A granted the same privilege to authorization ID B more than once, revoking that privilege from B nullifies all those grants.
Revoking WITH GRANT OPTION: The only way to revoke the WITH GRANT OPTION is to revoke ALL.
Privilege warning: Revoking a specific privilege from a user does not necessarily prevent that user from performing an action that requires that privilege. For example, the user may still have the privilege through PUBLIC or administrative privileges.
Corresponding system authorities: When
a type privilege is revoked, the corresponding system authorities
are revoked. For information about the system authorities that correspond
to SQL privileges see GRANT (Type Privileges).
Syntax alternatives: The following keywords are synonyms supported for compatibility to prior releases. These keywords are non-standard and should not be used:
Revoke the USAGE privilege on distinct type SHOESIZE from user JONES.
REVOKE USAGE ON DISTINCT TYPE SHOESIZE FROM JONES