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

Data authority control method and device, equipment and storage medium

A technology of data authority and control method, which is applied in the direction of database design/maintenance, digital data protection, computer security devices, etc., can solve the problem of high maintenance difficulty in the process of data authority control, achieve high maintenance difficulty, facilitate follow-up maintenance, reduce effect of difficulty

Pending Publication Date: 2022-05-24
PINGAN INT SMART CITY TECH CO LTD
View PDF0 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The present invention provides a data authority control method, device and computer-readable storage medium, the main purpose of which is to solve the problem of high maintenance difficulty in the data authority control process

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
  • Data authority control method and device, equipment and storage medium
  • Data authority control method and device, equipment and storage medium
  • Data authority control method and device, equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0060] It should be understood that the specific embodiments described herein are only used to explain the present invention, but not to limit the present invention.

[0061]The embodiment of the present application provides a data permission control method. The execution subject of the data permission control method includes, but is not limited to, at least one of electronic devices that can be configured to execute the method provided by the embodiments of the present application, such as a server and a terminal. In other words, the data permission control method can be executed by software or hardware installed in the terminal device or the server device. The server includes but is not limited to: a single server, a server cluster, a cloud server or a cloud server cluster, and the like. The server can be an independent server, or can provide cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communications, middleware ...

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 invention relates to an artificial intelligence technology, and discloses a data authority control method, which comprises the following steps of: constructing a data authority control table of a preset database; intercepting an SQL statement accessing a preset database; analyzing the SQL statement to obtain a user role, an object data table and a filtering condition of the object data table; querying operable data tables corresponding to the user roles and filtering conditions of each operable data table from the data authority control table; judging whether the object data table is in the operable data table or not; if the SQL statement is not in the operable data table, prohibiting the access of the SQL statement; if the object data table is in the operable data table, constructing a data screening model according to the filtering condition and the filtering condition of the operable data table; and screening out operable data of the user role in the object data table by utilizing the model, and performing access operation on the operable data by utilizing the SQL statement. The invention further provides a data authority control device, equipment and a medium. The maintenance difficulty of the data authority control process can be reduced.

Description

technical field [0001] The present invention relates to the technical field of artificial intelligence, and in particular, to a data permission control method, apparatus, electronic device and computer-readable storage medium. Background technique [0002] In order to protect the security and stability of the data in the database, it is usually necessary to perform permission control on the database data, that is, assign different database data operation permissions to different users, so that users with specific permissions can control the data covered by the specific permissions. The table or table field executes database data operations such as addition, deletion, modification, and query specified by the specific authority. [0003] At present, a common practice in the industry is to add SQL statements to access database data in business code to control permissions. This method has the following drawbacks: [0004] On the one hand, for complex SQL statements, for example...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F21/62G06F40/205G06F16/21G06F16/242
CPCG06F21/6227G06F40/205G06F16/21G06F16/242
Inventor 李勇
Owner PINGAN INT SMART CITY TECH CO LTD
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

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