REVOKE Non-SQL Definition Privilege

Revokes from one or more users or groups the privilege of referencing a non-SQL-defined schema in an SQL schema definition.
idms
Revokes from one or more users or groups the privilege of referencing a non-SQL-defined schema in an SQL schema definition.
Authorization
To revoke USE privilege on a non-SQL-defined schema, you must hold one of these privileges:
  • Grantable USE privilege on the non-SQL-defined schema
  • DBADMIN on the dictionary containing the non-SQL schema definition
  • SYSADMIN
You must be connected to the dictionary containing the non-SQL-defined schema when you issue the statement.
Syntax
►►─── REVOKE ─┬─ USE     ─┬───────────────────────────────────────────────────►               └─ DISPLAY ─┘    ►─── ON NONSQL SCHEMA V
nnnn
.
nonsql-schema-name
 ──────────────────────────────►               ┌─────────────── , ──────────────┐  ►─── FROM ─▼─┬─ PUBLIC ───────────────────┬─┴────────────────────────────────►◄               └─ 
authorization-identifier
 ─┘
Parameters
 
  • USE
    Specifies that you are revoking the USE privilege on the non-SQL-defined schema identified in the ON parameter to the users or groups identified in the FROM parameter.
  • DISPLAY
    Specifies that you are revoking the DISPLAY privilege on the non-SQL-defined schema identified in the ON parameter to the users or groups identified in the FROM 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.
  • FROM
    Specifies the users or groups from whom you are revoking the USE privilege.
  • PUBLIC
    Specifies all users.
    The privilege must have been previously given to PUBLIC by means of the GRANT statement.
  • authorization-identifier
    Identifies a user or group.
    The privilege must have been previously given to
    authorization-identifier
    by means of the GRANT statement.
    Expanded syntax for
    authorization-identifier
    is presented in Notes on Security Statement Syntax.
Revoking Use of a Non-SQL-Defined Schema
The following statement revokes the privilege of referencing a non-SQL-defined schema when creating an SQL schema:
revoke use   on nonsql schema v0001.ap   from sam;
More Information
For more information
about granting the privilege to use a non-SQL-defined schema
, see GRANT Non-SQL Definition Privilege.