
This form of the REVOKE statement removes the privileges on a created global variable.
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--+------------+-+--ON VARIABLE-----------------> | .-,---------. | | V | | '---+-ALTER-+-+-------' +-READ--+ '-WRITE-' .-,-------------. .-,----------------------. V | V | >----variable-name-+--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 a variable, it nullifies any grant of the privilege on that variable, 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 a global variable privilege is revoked, the corresponding system authorities are revoked. For information on the system authorities that correspond to SQL privileges see GRANT (Global Variable Privileges).
REVOKE the WRITE privilege on a global variable MYSCHEMA.MYJOB_PRINTER from user ZUBIRI.
REVOKE WRITE ON VARIABLE MYSCHEMA.MYJOB_PRINTER FROM ZUBIRI
