DB2 10.5 for Linux, UNIX, and Windows

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

Syntax


>>-REVOKE USAGE ON--XSROBJECT--xsrobject-name--FROM--PUBLIC----->

   .-BY 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