Page Comparison

This list of user accounts is as of 4/25/155th June 2014, and is based on the field coordinator inventory user list provided by Timoteo (attached)Moz office. This set of users and permissions has been backed-up, and can be restored at any point.

...

Moz User Accounts by Province.xlsx

SQL to check user's role assignments

select u.username
    , u.email
    , u.verified
    , u.active
    , r.name as roleName
    , p.name as programName
    , dz.name as deliveryZoneName
from users u
left join role_assignments ra on (ra.userid=u.id)
left join roles r on (r.id=ra.roleid)
left join programs p on (p.id=ra.programid)
left join delivery_zones dz on (dz.id=ra.deliveryzoneid)
order by username