This message appears when a REVOKE statement attempts to remove a privilege from an authorization that was granted WITH GRANT OPTION. The authorization has granted the privilege to one or more other authorizations.
REVOKE the privilege from these other authorizations before attempting the original REVOKE statement again.