Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

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

Active Publication Date: 2022-08-02
BEIJING YOYO TIANYU SYST TECH
View PDF31 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] Most database systems do not support field-level management, such as relational databases such as Oracle and MySQL;

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Database authority management and data protection method and device, equipment and storage medium
  • Database authority management and data protection method and device, equipment and storage medium
  • Database authority management and data protection method and device, equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

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...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The embodiment of the invention provides an authority management and data protection method and device applied to a database, equipment and a computer readable storage medium. The method comprises the following steps: according to the type of a user, performing unified authorization on a table in a database and rows and fields in the table, and constructing a user permission table; receiving an SQL statement of an access database, and obtaining an operation authority table corresponding to an access user at the same time; calling an operation authority of the access user on a table in a database and a field and a row in the table from the authority table; modifying an SQL (Structured Query Language) statement according to the operation authority of the access user on a table in a database, a field and a row in the table and the SQL statement accessing the database; and accessing the database through the modified SQL statement to obtain data content corresponding to the authority of the access user. In this way, the authority of the physical data storage system is improved, and data protection can be achieved without modifying the data content of the physical data storage system.

Description

technical field [0001] The embodiments of the present application relate to the field of data processing, and in particular, to rights management and data protection methods, apparatuses, devices, and computer-readable storage media applied to databases. Background technique [0002] A database is a "warehouse that organizes, stores and manages data according to data structures". It is a collection of large amounts of data stored in the computer for a long time, organized, sharable, and uniformly managed. [0003] There are many kinds of existing databases, and users can select the desired database type according to different usage requirements. [0004] However, the existing database still has the following shortcomings: [0005] Most NoSQL database systems do not have a permission management system; [0006] Most database systems do not support field-level management, such as relational databases such as Oracle and MySQL; [0007] Data protection is mostly achieved by ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F16/22G06F16/242G06F16/28G06F21/60
CPCG06F16/2282G06F16/2433G06F16/284G06F21/602G06F21/604G06F2221/2141
Inventor 姚宏宇朱朝强
Owner BEIJING YOYO TIANYU SYST TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products