Aikesheng Open Source Community

Feb 7, 2021 · Databases

Using Partial Revokes in MySQL 8.0.16 to Revoke Granular Permissions

This article explains MySQL's Partial Revokes feature introduced in version 8.0.16, showing how to enable the partial_revokes system variable, grant and selectively revoke SELECT privileges at both coarse and fine granularity, and verify the resulting restrictions using SHOW GRANTS and the mysql.user table.