Permission is a common basic function in the daily office system. In the system with permission module, it defines which resources login users can operate and which resources they cannot operate. The permission module can effectively control the specific operations of people with different identities who participate in the system. It can be said that a mature back-end system cannot do without a relatively perfect permission management system.

Permission management mode

RBAC model

RBAC model (Role-based Access Control: Role-based access control (RBAC96) model is a relatively early model of permission implementation, which was put forward in the multi-user computer period. RBAC96 model proposed by The Information Security Technology Laboratory (LIST) of George Mason University in the United States is the most representative model, and has been widely recognized.

RBAC believes that the process of authorization can be abstractly summarized as: Whether Who can access What How and determine whether this logical expression is True is the process of solving, that is, transforming the permission problem into Who, What and How, Who, What and How constitute the access triplet. For specific theories, please refer to RBAC96.

The composition of RBAC

In the RBAC model, there are three basic components: users, roles, and permissions. The relationship between them is shown in the figure below

[External link image transfer failed, the source site may have anti-theft mechanism, it is recommended to save the image directly upload (IMG-elayCNMD-1600669817752)(imgkr.cn-bj.ufileos.com/361aa5f7-30…)]

  • User: Each User is identified by a unique UID and is granted a different role
  • Role: Different roles have different rights
  • Permission: Access Permission
  • User-role mapping: Mapping between users and roles
  • Role-permission mapping: mapping between roles and permissions

For example, administrators and common users are granted different permissions. Common users can only modify and view personal information, but cannot create or freeze users. Administrators are granted all permissions, so they can do all operations.

[External link image transfer failed, the source site may have anti-theft mechanism, it is recommended to save the image directly upload (img-EJTCPTGF-1600669817757)(imgkr.cn-bj.ufileos.com/f1616af4-49…)]

RBAC model classification

Base model RBAC0

RBAC0 is the foundation on which many products can build permission models. In this model, we assign permissions to roles and roles to users. Users and roles and roles and permissions are many-to-many relationships. The permissions of a user are equal to the sum of the permissions of all roles.

[External link image transfer failed, source station may have anti-theft mechanism, it is recommended to save the image directly upload (IMG-LzzqWW2T-1600669817760)(imgkr.cn-bj.ufileos.com/f1a4d061-77…)]

Here’s an example:

For example, if we make an enterprise management product, it will be very troublesome to assign permissions to each user according to the traditional permission model, and it is impossible to modify user permissions in batches. At this point, you can abstract several roles, such as sales manager, financial manager, and marketing manager, and assign permissions to these roles and then assign roles to users. In this way, you only need to modify the relationship between a user and a role or the relationship between a role and a permission to assign or modify permissions in the future, which is more flexible and convenient. In addition, if a user has multiple roles, for example, Mr. Wang is responsible for both sales and marketing, then Mr. Wang can be given two roles, namely sales manager and marketing manager, so that he has all the permissions for both roles.

Role layering model RBAC1

RBAC1 builds on RBAC0 and introduces the concept of inheritance in roles. In simple terms, roles can be divided into several levels, and each level has different rights to achieve more fine-grained rights management.

[Img-YJRNHEAB-1600669817764] [Img-YJRNHEAB-1600669817764]

Here’s an example:

Based on the previous RBAC0 example, we found that the sales manager of a company may be divided into several levels. For example, in addition to the sales manager, there is also the deputy sales manager, and the deputy sales manager only has part of the authority of the sales manager. At this point, we can adopt the RBAC1 hierarchical model to divide the role of sales manager into multiple levels, and assign a lower level to the deputy sales manager.

Role constraint model RBAC2

RBAC2 also builds on RBAC0, but adds restrictions on users, roles, and permissions. These restrictions can be divided into two categories, namely Static Separation of Duty (SSD) and Dynamic Separation of Duty (DSD). Specific restrictions are shown below:

[Img-bbq39GEy-1600669817767)(imgkr.cn-bj.ufileos.com/9d61cf6c-bc…)]

Here’s an example:

For example, if a user is assigned the role of sales manager, he cannot be assigned the role of financial manager. Otherwise, he can enter the contract and review the contract by himself. For example, some companies are very important to the promotion of the role, a salesman to be promoted to sales manager, must be promoted to sales director, at this time the use of prerequisites.

Unified model RBAC3

RBAC3 is a combination of RBAC1 and RBAC2, so RBAC3 includes both role layering and restrictions that can be added.

[External link image transfer failed, source station may have anti-theft mechanism, it is recommended to save the image directly upload (IMG-83yD90HG-1600669817770)(imgkr.cn-bj.ufileos.com/6d251da9-b3…)]

Case practice ~RBAC0 model core table structure

Through the above analysis, it can be seen that there are four models of RBAC, and the last three are extended from the RBAC0 basic model. Here, the design of the RBAC0 table of the basic model is mainly considered. After having the basic table structure, it can be upgraded on the basis of it.

Entity correspondence

The mapping between users, roles, and resource entities is described as follows

[ImG-JBU21U94-1600669817772] [ImG-JBU21U94-1600669817772]

Users here for many, the corresponding relationship between character entity role relationship is same to the corresponding relationship between resources and so on the physical design increase user role entity between user and role, will be broken down into a many-to-many relation between one-to-many, similarly, split out the roles and resources many-to-many relation between entity object permissions entity in the middle. Need video supporting materials or other information + our little sister V Lezijie007 (add friends code -98, no remarks no add)

Table structure design

From the analysis of the entity mapping relationship above, the permission table design is divided into the following five basic table structures: user table (T_USER), role table (T_ROLE), T_user_role (user role table), resource table (T_module), and t_permission table. The table structure relationship is as follows:

[External link image transfer failed, the source site may have anti-theft mechanism, it is recommended to save the image directly upload (img-bmenukot-1600669817775)(imgkr.cn-bj.ufileos.com/a92de347-52…)]

t_user The users table
field The field type Field limits The field
A primary key id int(11) Since the increase The primary key id
user_name varchar(20) Is not empty The user name
user_pwd varchar(100) Is not empty The user password
true_name varchar(20) Can be null Real name
email varchar(30) Can be null email
phone varchar(20) Can be null The phone
is_valid int(4) Can be null Valid state
create_date datetime Can be null Creation time
update_date datetime Can be null Update time
t_role Character sheet
field The field type Field limits The field
A primary key id int(11) Since the increase The primary key id
role_name varchar(20) Is not empty The role of
role_remarker varchar(100) Can be null Role of note
is_valid int(4) Can be null Valid state
create_date datetime Can be null Creation time
update_date datetime Can be null Update time
t_user_role User role table
field The field type Field limits The field
A primary key id int(11) Since the increase The primary key id
user_id int(4) Is not empty The user id
role_id int(4) Character id Character id
create_date datetime Can be null Creation time
update_date datetime Can be null Update time
t_module Resource table
field The field type Field limits The field
A primary key id int(11) Since the increase Resource id
module_name varchar(20) Can be null Resource name
module_style varchar(100) Can be null Resource style
url varchar(20) Can be null Resource URL address
parent_id int(11) Is not empty Upper-layer Resource ID
parent_opt_value varchar(20) Is not empty Permission code of the upper-layer resource
grade int(11) Is not empty The hierarchy
opt_value varchar(30) Can be null Access code
orders int(11) Is not empty Order no.
is_valid int(4) Can be null Valid state
create_date datetime Can be null Creation time
update_date datetime Can be null Update time
t_permission Permissions on the table
field The field type Field limits The field
A primary key id int(11) Since the increase The primary key id
role_id int(11) Is not empty Character id
module_id int(11) Is not empty Resource id
acl_value varchar(20) Is not empty Access code
create_date datetime Can be null Creation time
update_date datetime Can be null Update time

Module partition

Table structure design can be seen: there are three main tables (T_user, T_role, t_module), function is divided into three modules:

User management

  • Maintain basic user information

  • User Role Assignment

Role management

  • Maintain basic role information
  • Role authorization (assigning menus for roles to operate)
  • Role authentication (Verifying the permissions of roles)

Resource management

  • Resource Information Maintenance
  • Menu output dynamic control

extension

Rbac-based extension – user groups

Based on the RBAC model, it can be extended to make it more suitable for our products. For example, add the concept of user groups, assign roles to user groups, and add users to user groups. In this way, the user has all the rights of the user group in addition to its own rights.

[External link image transfer failed, the source site may have anti-theft mechanism, it is recommended to save the image directly upload (IMG-8EBJCRJB-1600669817776)(imgkr.cn-bj.ufileos.com/c115fb92-66…)]

Here’s an example:

For example, we can view a department as a user group, such as sales department and Finance Department, and assign roles to the department so that all users in the department have department permissions. The concept of user group can easily authorize group users without affecting the role permissions that users already have.