GRANT Non-SQL Definition Privilege Parameters

USE

Gives the USE privilege on the non-SQL-defined schema identified in the ON parameter to the users or groups identified in the TO parameter.

DISPLAY

Gives the DISPLAY privilege on the non-SQL-defined schema identified in the ON parameter to the users or groups identified in the TO parameter.

ON NONSQL SCHEMA

Specifies the non-SQL-defined schema to which the USE privilege applies.

Vnnnn.nonsql-schema-name

Specifies the version number and name of the non-SQL-defined schema. The version number (nnnn) must include leading zeros.

You can wildcard nonsql-schema-name. You cannot wildcard Vnnnn. The wildcard character is valid after the period following Vnnnn.

Note: For more information about wildcarding, see Using a Wildcard.

TO

Specifies the users or groups to whom you are giving the USE privilege.

PUBLIC

Specifies all users.

authorization-identifier

Identifies a user or group.

Note: Expanded syntax for authorization-identifier is presented in Notes on Security Statement Syntax.

WITH GRANT OPTION

Gives the privilege of granting the USE privilege on the named resource to the users or groups identified in the TO parameter.

A privilege granted with the WITH GRANT OPTION is called a grantable privilege.

Granting USE On a Non-SQL-Defined Schema

The following statement grants the privilege of referencing a non-SQL-defined schema when creating an SQL schema:

grant use
  on nonsql schema v0001.ap
  to sal, sam;