Multiple grants: If the same privilege is granted to the same user more than once, revoking that privilege from that user nullifies all those grants.
If you revoke a privilege, it nullifies any grant of that privilege, 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.
If more than one system authority will be revoked with an SQL privilege, and any one of the authorities cannot be revoked, then a warning occurs and no authorities will be revoked for that privilege.
Corresponding system authorities: When a table privilege is revoked, the corresponding system authorities are revoked, except:
For information on the system authorities that correspond to SQL privileges see GRANT (Table or View Privileges).
Revoking either the INDEX or ALTER privilege, revokes the system authority *OBJALTER.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.