GRANT (type or JAR file privileges)
This form of the GRANT statement grants the privilege to use distinct types or JAR files.
Syntax
.-,------------------. V | >>-GRANT----USAGE ON----+-TYPE----distinct-type-name-+-+--------> | .-,--------. | | V | | '-JAR----jar-name-+------------' .-,----------------------. V | >--TO----+-authorization-name-+-+--+-------------------+------->< +-ROLE--role-name----+ '-WITH GRANT OPTION-' '-PUBLIC-------------'
Description
- USAGE
- Grants the privilege to use the distinct type in tables, functions procedures, or the privilege to use the JAR file.
- TYPE distinct-type-name
- Identifies the distinct type. The name, including the implicit or explicit schema name, must identify a unique distinct type that exists at the current server.
- JAR jar-name
- Identifies the JAR file. The name, including the implicit or explicit schema name, must identify a unique JAR file that exists at the current server.
- TO
- Refer to GRANT for a description of the TO clause.
- WITH GRANT OPTION
- Refer to GRANT for a description of the WITH GRANT OPTION clause.
Notes
Alternative syntax and synonyms: To provide compatibility with previous releases of DB2 or other products in the DB2 family, DB2 supports DATA TYPE or DISTINCT TYPE as a synonym for TYPE.
Examples
Example 1: 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 TYPE SHOE_SIZE TO JONES;
Example
2: Grant the USAGE privilege on distinct type US_DOLLAR to all
users at the current server.
GRANT USAGE ON TYPE US_DOLLAR TO PUBLIC;
Example
3: Grant the USAGE privilege on distinct type CANADIAN_DOLLAR
to the administrative assistant (ADMIN_A), and give this user the
ability to grant the USAGE privilege on the distinct type to others.
The administrative assistant cannot grant the privilege to execute
the cast functions that are associated with the distinct type CANADIAN_DOLLAR
because WITH GRANT OPTION does not give the administrative assistant
the EXECUTE authority on these cast functions.
GRANT USAGE ON TYPE CANADIAN_DOLLAR TO ADMIN_A
WITH GRANT OPTION;
Example 4: Grant the USAGE privilege on the distinct
type MILES to role ROLE1 at the current server:
GRANT USAGE ON TYPE MILES
TO ROLE ROLE1;