This question already has an answer here:
- Storing menu items with user permissions 3 answers
What would be the most efficient way to store a users role(in my case) in the database?
What my user table looks like:
id int(AI) username varchar(80) password varchar(255)
For example the rights would be like this:
There should be rights to see a page:
So in the case above you should be allowed to either have the right to see Page1 and Page2 but also just Page3
- Delete post
- Create post
- Edit post
on just Page2
All these possibilities of combinations should have their own role.
Now I dont know how to store this in a table.
I thought about creating a table like this:
role | page1 | page2 | page3 | page4 | page5 | page6 | delete | create | edit | role1| yes | yes | no | no | no | no | yes | yes | yes |
But I think there's way too many combinations to use this so there must be a better/efficient/easier way to do this.
So my question is:
What is the best/easiest way to do this?