Description
- ALL or ALL PRIVILEGES
- 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. Note that granting ALL PRIVILEGES on a distinct 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.
- ALTER
- Grants the privilege to use the COMMENT statement.
- USAGE
- Grants the privilege to use the distinct type in tables, functions, or procedures.
- ON DISTINCT TYPE distinct-type-name
- Identifies the distinct types on which the privilege is granted. The distinct-type-name must
identify a distinct type that exists at the current server.
- TO
- Indicates to whom the privileges are granted.
- authorization-name,...
- Lists one or more authorization IDs.
- PUBLIC
- Grants the privileges to a set of users (authorization IDs). For more
information, see Authorization, privileges and object ownership.
- WITH GRANT OPTION
- Allows the specified authorization-names to
grant privileges on the distinct types specified in the ON clause to other users.
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).
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.