Hi,
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.
A.
-----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
On Wed, Oct 22, 2008 at 1:24 PM, Brion Vibber brion@wikimedia.org wrote:
-----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-----
The UserRightsList extension < http://www.mediawiki.org/wiki/Extension:UserRightsList%3E provides a nifty interface for this. It doesn't seem to work for the trunk version, though. :(
Hi, If you do not disdain windows and Microsoft products you can accomplish the task quite easily e.g. with Excel and VBA A. Cremer
"André Meunier" ameunier@ulg.ac.be schrieb im Newsbeitrag news:48FEE53B.5060702@ulg.ac.be...
Hi,
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.
A.
mediawiki-l@lists.wikimedia.org