REVOKE (XSR object privileges) statement

This form of the REVOKE statement revokes USAGE privilege on an XSR object.

Invocation

The REVOKE statement can be embedded in an application program or issued through the use of dynamic SQL statements. It is an executable statement that can be dynamically prepared only if the DYNAMICRULES run behavior is in effect for the package (SQLSTATE 42509).

Authorization

One of the following authorities is required:
  • ACCESSCTRL or SECADM authority or ACCESSCTRL authority on the schema containing the XSR object

Syntax

Read syntax diagramSkip visual syntax diagramREVOKE USAGE ONXSROBJECTxsrobject-nameFROMPUBLICBY ALL

Description

ON XSROBJECT xsrobject-name
This name identifies the XSR object for which the USAGE privilege is revoked. The xsrobject-name, including the implicit or explicit schema qualifier, must uniquely identify an existing XSR object at the current server. If no XSR object by this name exists in the specified schema, an error is raised (SQLSTATE 42704).
FROM PUBLIC
Revokes the USAGE privilege from PUBLIC.
BY ALL
Revokes each named privilege from all users who were explicitly granted those privileges, regardless of who granted them. This is the default behavior.

Example

Revoke usage privileges on the XML schema MYSCHEMA from PUBLIC: 
   REVOKE USAGE ON XSROBJECT MYSCHEMA FROM PUBLIC