Page MenuHomePhabricator

Removing some userrights from hiwiki
Closed, ResolvedPublic

Description

Things one discover... The silly ex-administrator user group was removed from hiwiki configuration as per T37355; however users in the ex-administrator user group remains and, since they don't exist anymore on-wiki, this has to be removed directly through the database. Thank you.

Event Timeline

Would prefer to re-add it temporarily, have a steward remove the groups, and then remove again, so it gets logged on-wiki.

We can't remove those user rights via Meta. I don't think this is
controversial, since such usergroup only granted autopatrol rights. It's
easier and less work to do it via the DB IMHO. Thanks.

Krenair claimed this task.
mysql:wikiadmin@db1038 [hiwiki]> select * from user_groups where ug_group = 'Ex_Administrator';
+---------+------------------+
| ug_user | ug_group         |
+---------+------------------+
|       4 | Ex_Administrator |
|     466 | Ex_Administrator |
|   17797 | Ex_Administrator |
+---------+------------------+
3 rows in set (0.02 sec)

mysql:wikiadmin@db1038 [hiwiki]> delete from user_groups where ug_group = 'Ex_Administrator';
Query OK, 3 rows affected (0.00 sec)

mysql:wikiadmin@db1038 [hiwiki]> select * from user_groups where ug_group = 'Ex_Administrator';
Empty set (0.00 sec)