Access Control User in Replication

[haoqili]

In the Access Control demo, there are 4 users: "regular_alice", "regular_bob", "super_foo", and "super_bar".

It's easy to recreate the 2 regular users, just simply let the users register those 2 users with the correct usernames (given that I don't dump the auth_user table to them, if I do, they'll have to delete those 4 entries since their HMAC keys for passwords are different).

However the super users are a bit challenging to replicate. They are "super" because they are added to a super user group, hince they have foreign keys in auth_user_groups.

mysql> select * from auth_user_groups;

+----+---------+----------+
| id | user_id | group_id |
+----+---------+----------+
|  4 |      36 |        6 |
|  3 |      37 |        6 |
+----+---------+----------+

Currently I'm thinking of making a sql query that does the creation/deletion/adding to groups of the 4 special users. This way whoever wants to replicate the data will just run this query.

Any better solutions?