Description

ALL or ALL PRIVILEGES
Revokes one or more distinct type privileges from each authorization-name. The privileges revoked are those privileges on the identified distinct types that were granted to the authorization-names. Note that revoking ALL PRIVILEGES on a distinct 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.

ALTER
Revokes the privilege to use the COMMENT statement.
USAGE
Revokes the privilege to use distinct types in tables, functions, procedures, or as the source type in a CREATE DISTINCT TYPE statement.
ON DISTINCT TYPE distinct-type-name
Identifies the distinct types from which you are revoking privileges. The distinct-type-name must identify a distinct type that exists at the current server.
FROM
Identifies from whom the privileges are revoked.
authorization-name,...
Lists one or more authorization IDs. Do not specify the same authorization-name more than once.
PUBLIC
Revokes the specified privileges from PUBLIC.