
This form of the REVOKE statement removes the privileges on an XSR object.
This statement can be embedded in an application program or issued interactively. It is an executable statement that can be dynamically prepared.
The privileges held by the authorization ID of the statement must include at least one of the following:
.-PRIVILEGES-. >>-REVOKE--+-ALL--+------------+-+------------------------------> | .-,---------. | | V | | '---+-ALTER-+-+-------' '-USAGE-' .-,--------------. V | >--ON--XSROBJECT----xsrobject-name-+----------------------------> .-,----------------------. V | >--FROM----+-authorization-name-+-+---------------------------->< '-PUBLIC-------------'
If you do not use ALL, you must use one or more of the keywords listed below. Each keyword revokes the privilege described.
Multiple grants: If you revoke a privilege on an XSR object, it nullifies any grant of the privilege on that XSR object, regardless of who granted it.
Revoking WITH GRANT OPTION: The only way to revoke the WITH GRANT OPTION is to revoke ALL.
Privilege warning: Revoking a specific privilege from a user does not necessarily prevent that user from performing an action that requires that privilege. For example, the user may still have the privilege through PUBLIC or administrative privileges.
Corresponding system authorities: When an XSR object privilege is revoked, the corresponding system authorities are revoked. For information about the system authorities that correspond to SQL privileges see GRANT (XML Schema Privileges).
Revoke the USAGE privilege on XSR object XMLSCHEMA from PUBLIC.
REVOKE USAGE ON XSRSOBJECT XMLSCHEMA FROM PUBLIC
