maria-discuss team mailing list archive

[Hartmut Holzgraefe <hartmut@xxxxxxxxxxx>]

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/