# Permission DB design

**URL:** <https://forum.kirupa.com/t/permission-db-design/195631>\
**Category:** Uncategorized\
**Created:** [August 2, 2006, 12:31am UTC](https://forum.kirupa.com/t/permission-db-design/195631 "2006-08-02T00:31:18Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![DHDesign](https://avatars.discourse-cdn.com/v4/letter/d/b19c9b/32.png) [@DHDesign](https://forum.kirupa.com/u/DHDesign)\
**Post date:** [August 2, 2006, 12:31am UTC](https://forum.kirupa.com/t/permission-db-design/195631/1 "2006-08-02T00:31:18Z")

</div>

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!