Menu
Community /Pin to ProfileBookmark
@NogDogAug 06.2020 — #
Probably the "right" way to do it in a relational database world. In the long run probably easier to maintain over time, as (a) it's pretty clear to see who has what permissions, and (b) it's easy to add new permissions when needed. But whether it's worth the bit of extra work to initially set it up, only you can answer.
Admin User Levels
I’m looking to have a admin-user table, I’ve done this plenty of times before with user levels 1,2,3,4 and 5 etc.
However the current project has (so far) 5 different functions with the requirement to add more.
Each user will be given differnet combination of permissions.
Two solutions could be
1. In my admin-users table, have a column for each function and have 1 or 0. I don’t like this as it will require consistant table changing.2. Have a admin-funcations table and a table linking users and functions together. It’s just messy.
Are there any other ways of doing this. Do recall in a .net project from 5-10 years ago using a single column for the permissions. By memory ininteger as there are 32 bits. You assigned each bit to a function.
Could this be done in MySQL and PHP?
Sign in
to post a comment4 Comments(s) ↴
0
@NogDogAug 06.2020 — #>@kiwis80#1621840 Have a admin-funcations table and a table linking users and functions together. It's just messy
Probably the "right" way to do it in a relational database world. In the long run probably easier to maintain over time, as (a) it's pretty clear to see who has what permissions, and (b) it's easy to add new permissions when needed. But whether it's worth the bit of extra work to initially set it up, only you can answer.