Page MenuHomePhabricator
Paste P8256

Audit wikidata-staff wikidata group for 2fa
ActivePublic

Authored by Addshore on Mar 21 2019, 2:37 PM.
Tags
None
Referenced Files
F28437032: raw.txt
Mar 21 2019, 2:37 PM
Subscribers
None
#on centralauth db
# Find users that are in the wikidata staff group
select user_name from user_groups INNER JOIN user ON ug_user = user_id where ug_group = "wikidata-staff";
# Find all wmde users and their 2fa status
SELECT gu_name, oathauth_users.id FROM globaluser LEFT JOIN oathauth_users ON gu_id = oathauth_users.id WHERE gu_name LIKE "%(WMDE)" ORDER BY oathauth_users.id;