Page MenuHomePhabricator

Remove 'editusercssjs' and 'sendemail-new-users' from global groups
Closed, ResolvedPublic

Description

The sysadmin global group, when queried, reports to still have 'editusercssjs' on their set.

The steward global group, when queried, reports to still have the 'sendemail-new-users' permissions on their set.

Those permissions no longer exist but given that they were not removed from the global group before deleting them, an SQL query is now needed to manually remove them.

Thank you.

Event Timeline

Framawiki subscribed.

Database action required per task desc.

Marostegui subscribed.

We don't run SQL commands directly into our DBs without them being wrapped into mediawiki. So I would suggest you create a maintenance script and when ready either run it yourself (if you have privileges to do so) or get Wikimedia-maintenance-script-run to do it for you.

Probably not worth a script, but I can do the query

Reedy claimed this task.
MariaDB [centralauth]> select * from global_group_permissions where ggp_permission IN ( 'editusercssjs', 'sendemail-new-users' );
+-----------+---------------------+
| ggp_group | ggp_permission      |
+-----------+---------------------+
| sysadmin  | editusercssjs       |
| steward   | sendemail-new-users |
+-----------+---------------------+
2 rows in set (0.01 sec)

MariaDB [centralauth]> delete from global_group_permissions where ggp_permission IN ( 'editusercssjs', 'sendemail-new-users' );
Query OK, 2 rows affected (0.00 sec)

MariaDB [centralauth]>