Okay, so maybe I should approach this another way. Does anyone know how to change all user roles on a Multisite network without doing so directly in the database?
Roles are per-site, not per network.
I understand that. What I want to know is if there is a way to change the roles across the entire network. Perhaps there is a MySQL query that can do it.
Change to what?
You’ll have to be more specific and use a concrete example here 🙂 Like…
Do you want to change all subscribers on Site A to Admins?
Do you want all users, on all sites, on the network to be Editors?
You can do it via plugins, but WHICH plugin depends on WHAT you’re doing 🙂 Changing ‘all users’ is a little vague to go from.
Thanks for the reply. I need to change all users on all sites, who are currently Admins, to be Editors.
I actually was able to do this in SQL Editor with a query.
UPDATE databasename.wp_usermeta SET meta_value = REPLACE(meta_value,’s:13:”administrator”;s:1:”1″;}’,’a:1:{s:6:”editor”;b:1;}’);
That’s the best way for it, sadly. It’s an edge case :/
