Syntax for Securing Database Resources › REVOKE Non-SQL Definition Privilege › Parameters

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.

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.

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.

Note: 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;