Database authority management and data protection method and device, equipment and storage medium
A technology of rights management and data protection, applied in the field of data processing, can solve problems such as not supporting field-level management, and achieve the effect of protection and data realization
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
specific Embodiment
[0081] Based on the database table logic_mysql_user, the authority of user A is authorized, and a user authority table is constructed. The user authority table includes:
[0082] The operation authority of the logic_mysql_user table is query (select);
[0083] The operation authority of the field id is query (select);
[0084] The operation authority of the field name is query (select);
[0085] The operation authority of the field dept_id is query (select);
[0086] The operation authority of the field id_card is query (select);
[0087] The encryption algorithm permission of the field id_card is md5;
[0088] Row level data right dept_id='d1'.
[0089] S120: Receive the SQL statement for accessing the database, and simultaneously obtain the operation authority table corresponding to the access user; and retrieve the operation authority of the access user on the table in the database and the fields and rows in the table from the authority table.
[0090] In some embodime...
PUM
Abstract
Description
Claims
Application Information
- R&D Engineer
- R&D Manager
- IP Professional
- Industry Leading Data Capabilities
- Powerful AI technology
- Patent DNA Extraction
Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.
© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com