Permission DB design

can i get feedback on the following please…

Goal: User Permission System without Groups (individual assignment)
Details:

  • 7 locations (LocA, LocB, LocC, LocD, LocE, LocF, LocG)
  • 5 Permissions (View, Add, Edit, Delete, Close)
  • when setting up a User, you get a checkbox matrix and assign Permissions to one or multiple Locations for the User

Example:
User1 = LocA -> View, Add
User2 = LocA -> View / LocB ->View, Add / LocC -> View, Add, Edit
User3 = LocE -> View, Add, Edit / LocF -> View
AND SO ON…

When setting up the user, a table with Locations as Column Headers and Permissions as Row Headers will be given with a series of checkboxes in the middle…any combination for multiple Locations/Permissions can be given to a User.

What is the best way to design this? I will post my idea in a sec.
Thank you!