User permission association method, query method and device

Abstract

The embodiment of the invention discloses a user permission association method, a user permission association device, electronic equipment and a storage medium. The method comprises the steps that thedata access permission of any role to a plurality of devices is stored through a bitmap data structure, one device corresponds to bit storage permission information, and 0 or 1 is used for representing whether one role has the data access permission of the corresponding device or not; the plurality of devices obtain a bitmap corresponding to the association relationship between the role and the devices according to the bit number storage permission information of one bitmap corresponding to a preset device number; an association relationship is established between each user and a plurality ofroles, and the bitmap of the association relationship between each corresponding role and the equipment and the association relationship between each user and the plurality of roles are stored in a database. According to the technical scheme provided by the embodiment of the invention, the occupation of the associated information data on the storage space can be reduced, and the response speed ofsystem data query and loading is improved.

Description

technical field [0001] The embodiments of the present application relate to the technical field of data association storage, and in particular, to a method for associating user rights, a query method, and a device. Background technique [0002] At present, in the application of computer system data access rights management, it is usually necessary to establish an association relationship between users and related devices, indicating that users have data access control rights to these devices. The traditional association management of user and device rights mainly adopts the design method of role rights based on RBAC (Role-Based Access Control, role-based access control). The proxy layer with specific device permissions is essentially a set of a certain number of permissions. Users are associated with specific devices through roles. A user has several roles, and each role has data access rights for several devices. In this way, an authorization model of "user-role-permissio...

AI Technical Summary

Problems solved by technology

For a single database, it is difficult to store such a huge amount of data

Regardless of whether the data is stored in a single database or a sub-database and sub-table mode, the speed of data query and data loading is relatively slow, and the system is prone to instability during the response process, which affects user use.

Images