Forum Discussion

ltduranltduran's avatar
ltduranltduran
Qrew Cadet
8 years ago

Roles and Permissions for Multiple Locations and Tiered Organizational Structure

We have a Corporate Headquarters and Multiple Stores. Our headquarters will need access to all stores. At each Store, there will need to be at least two different levels of access (possibly more). These levels of access will be the same across all of our stores; however, each store (regardless of what level of access that you have) should only have access to their respective store and its related records. What is the best way to organize this?

Thank You!
roles and permissions

6 Replies

Sort By
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    8 years ago
    At least at the high level you will have 2 tables.

    HQ & Stores.

    One way to handle access at the store level is to have a field on the stores table called "Users with access".
    This is a multi-select User field.  So as long as you don't have more than 20 'store users' per store.  Then you can use this field to indicate which users can view that store (and possibly all the child records).

    You will then have your 3 roles; HQ User, Store Management, Store Employee.
    Then you can apply the 'viewing' rights to the store users where they are listed in the 'users with access' field.

    If you are going to have more than 20 users per store, there are a few other ways to do this, but much more tricky to set up.
    • ltduranltduran's avatar
      ltduranltduran
      Qrew Cadet
      8 years ago
      Thanks for your reply! This sounds like a great solution. Is there a way to do a multi select user field? I can't seem to find it. Thanks!