[Mediawiki-l] multiple users to one group
Brion Vibber
brion at wikimedia.org
Wed Oct 22 17:24:41 UTC 2008
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
André Meunier wrote:
> Is there a way to assign multiple people to one group?
> I don't seem to find how to do that in sql in the database, I can see
> the users table, and the group table, but I don't find the link between
> them.
> And in the web interface, the Special:permissions can only do it one
> user at a time.
There's not a built-in user interface for changing group memberships for
multiple accounts at once, but you could do it manually in the database
something like this:
INSERT INTO user_groups (ug_user,ug_group)
SELECT user_id, 'target_group' FROM user
WHERE user_name IN ('First username', 'Second username', 'Third username');
- -- brion
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.8 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iEYEARECAAYFAkj/YdkACgkQwRnhpk1wk46FmgCgzkz9QPeUIukUcRc3mgu6ZwmM
MY0An163QyjDKF4KjjfhMKhL6H83p3ni
=OJ/N
-----END PGP SIGNATURE-----
More information about the MediaWiki-l
mailing list