Re: Making a bulk change to User Account Passwords

Hi Tina,

Take a look at this plugin that will make it easy to set user permissions:
https://www.interactivetools.com/add-ons/bulk-user-access-editor/

Hi csdesign, 

Yes, it's stored in a table called '_accessList', you can see it here: admin.php?menu=database&action=editTable&tableName=_accessList

You'd have to import into that table or use MySQL to insert/update the entries.

Hope that helps!

Is it at all possible to split the non-administrators into two groups?  I believe I asked before about dividing users into two different User Account groups - and it wasn't possible. Not sure if the same situation applies to this plugin. 

For instance, Half of the group I need to give access to add/edit horses only, the other half I need to give access to add/edit mules only.  (screenshot attached). 

Thanks! Tina

Hi Tina, 

It doesn't do that by default, no.  You'd have to how you were going to identify the two groups and what MySQL WHERE query would select them.

In the plugin there's the following code: 

  /* Check for selected group of users and make the where condition
    1 - all
    2 - administrators
    3 - non administrators
  */
  if(@$_REQUEST['userGroup'] == 1) {
    $accountsQueryWhere = "num";
  }
  elseif(@$_REQUEST['userGroup'] == 2) {
    $accountsQueryWhere = "isAdmin = 1";
  }
  elseif(@$_REQUEST['userGroup'] == 3) {
    $accountsQueryWhere = "isAdmin = 0";
  }
  else {
    alert("Invalid user group.");
  }

If you (backup first!) temporarily changed the value of non-admins (3) to say "isAdmin = 0 AND otherField = 1" then you could further filter the users.

It would probably take some trial and error.

Hope that helps and good luck!

Sounds good, thank you!  I will backup then hack away at it!! ;) 

I do have a radio button that defines each of them at the beginning of each user account (attached image). If I can use that, then that will work great because they are already defined there. 

Thanks again! Tina