GRANT Non-SQL Definition Privilege

Gives one or more users or groups the privilege of referencing a non-SQL-defined schema in an SQL schema definition.
idms
Gives one or more users or groups the privilege of referencing a non-SQL-defined schema in an SQL schema definition.
GRANT Non-SQL Definition Privilege Authorization
To grant the USE privilege on a non-SQL-defined schema, you must hold one of these privileges:
  • Grantable privilege on the non-SQL-defined schema (you can grant the privilege, but you cannot specify WITH GRANT OPTION).
  • DBADMIN on the dictionary containing the non-SQL-defined schema definition.
  • SYSADMIN.
You must be connected to the dictionary containing the non-SQL-defined schema when you issue the statement.
GRANT Non-SQL Definition Privilege Syntax
►►─── GRANT ─┬─ USE     ─┬────────────────────────────────────────────────────►              └─ DISPLAY ─┘    ►─── ON NONSQL SCHEMA V
nnnn
.
nonsql-schema-name
 ──────────────────────────────►             ┌─────────────── , ──────────────┐  ►─── TO ─▼─┬─ PUBLIC ───────────────────┬─┴──────────────────────────────────►             └─ 
authorization-identifier
 ─┘    ►─┬─────────────────────┬────────────────────────────────────────────────────►◄    └─ WITH GRANT OPTION ─┘
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.
  • V
    nnnn
    .
    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 V
    nnnn
    . The wildcard character is valid after the period following V
    nnnn
    .
    For more information on 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.
    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;
GRANT Non-SQL Definition Privilege More Information
For more information on revoking the privilege to use a non-SQL-defined schema, see REVOKE Non-SQL Definition Privilege.