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.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.