When trying to make things better, make it very complicated. I was working on a Security Threat Tool script when I had to learn more about the interaction between static and dynamic privileges in MySQL 8. Dynamic privileges is a “new” thing added in MySQL 8 to easily extend the privileges definition, and at the [&]

https://www.percona.com/blog/2021/06/15/mysql-static-and-dynamic-privileges-part-1/