The permission management system is now a background management system and does not know how to assign permissions better. For example, only administrators can add new common administrators. Common administrators can only do common tasks. How should we design databases? Share To: permission management system
Now I am working on a background management system. I don't know how to assign permissions better.
For example:
Only administrators can add new common administrators.
Common administrators can only do common tasks.
How should we design databases?
Share:
------ Solution --------------------
To put it simply, add a permission field in the user table, such as The rid field, which can be identified by the rid field.
------ Solution --------------------
A role table is required.
------ Solution --------------------
Add a permission field to store the operation permissions of the field action.
Then, each action is matched. If yes, the action can be executed. If no action exists, the action is not executed.