Comments - REVOKE
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
Is there a way to revoke all granted roles?
Like REVOKE ALL ROLES FROM foo; (Similar to REVOKE ALL FROM)
Or maybe by editing some mysql tables?
No - added as a feature request at MDEV-9691.
Also it looks like REVOKE role FROM foo; is not idempotent.
And does not work in prepared statements.'