On 05.09.20 12:39, Reindl Harald wrote:
and how does json crap magically solve the issue?
no more used table schema changes, only table content changes from now on whenever privileges are added from now on. When adding a new privilege no changes on the existing users are even needed at all. When splitting up existing privileges to become more granular the story is a bit more complicated though, see e.g.: https://jira.mariadb.org/browse/MDEV-23610 (That problem is not really json specific though, it would have been the same with the old "one column per privilege" approach. The json change lowered the bar for adding new privileges a bit though) -- Hartmut Holzgraefe, Principal Support Engineer (EMEA) MariaDB Corporation | http://www.mariadb.com/