WL#12820: Extend GRANT syntax to cover partial revokes information

Affects: Server-8.0   —   Status: Complete

WL#12098 introduced concept of partial revokes associated with global privileges
grants. In an HA environment, grants and revoke require knowledge of grantor's
context to be able to replicate the effect of the grant uniformly across
different nodes. This is done by adding grantor's information in binary log's
query log event header. Secondary nodes use this information to set required
context and replay grant/revoke.

However, for tools like mysqlbinlog, there is no way to set grantor's context
because it uses a regular libmysqlclient connection. This impacts point in time
recovery using mysqlbinlog because grants can not be replayed reliably.

This worklog aims at introducing extensions to GRANT/REVOKE syntax such that
partial revoke information is passed as a part of SQL itself. Feature will make
sure that rewritten GRANT/REVOKE are not dependent on grantor's information and
can be replayed uniformly on any node.