Data access control method and device

A data access control and database technology, applied in the field of information security, can solve problems such as management and audit difficulties, affect data processing efficiency, and long implementation cycle, so as to improve data utilization and system service capabilities, enrich user authority management scenarios, and improve Effects of Reliability and Flexibility

Pending Publication Date: 2020-07-28
INDUSTRIAL AND COMMERCIAL BANK OF CHINA
View PDF6 Cites 12 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This method, on the one hand, relies too much on the database's own authority management mechanism. The number of database accounts is limited and cannot meet the growth of the number of users. The authority of the database granularity needs to create a view to achieve data table level, specific scope access control and sensitive information shielding, maintenance costs High and difficult to manage and audit; on the other hand, the permission information of the database is only valid in a single database cluster, and each cluster needs to be configured separately and released through the application version. The approval process is complicated and the implementation cycle is long, which seriously affects the overall data processing efficiency

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 access control method and device
  • Data access control method and device
  • Data access control method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0035] In order to enable those skilled in the art to better understand the technical solutions in this specification, the technical solutions in the embodiments of the application will be clearly and completely described below in conjunction with the drawings in the embodiments of the application. Obviously, the described The embodiments are only some of the embodiments of the present application, but not all of them. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the scope of protection of this application.

[0036]Based on this, in order to improve the reliability and flexibility of data access control and at the same time improve the versatility of application scenarios, the embodiment of the present application provides a data access control device, which may be a server or a client device, and the client Terminal devices can include smart phones, tablet electro...

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 provides a data access control method and device. The method comprises the steps: receiving a database access request of a target user, the database access request comprising user information and a target SQL statement list; sequentially obtaining statement types of all SQL statements which are in an unprocessed state currently in the target SQL statement list, and judging whether the target user has the access permission of the target data or not according to the user information, preset permission information for the user to access the database and a statement type, If so, sending the SQL statement to the target database. According to the invention, the reliability and flexibility of data access control can be improved, and the universality of an application scene can be improved.

Description

technical field [0001] The present application relates to the technical field of information security, in particular to a data access control method and device. Background technique [0002] In the context of the data-oriented era, a large amount of data is stored centrally in the database. In various application scenarios, such as customer marketing, business analysis, and enterprise management, the data in the database can be processed and processed in a variety of ways through SQL statements. Therefore, how to quickly share data among different business departments on the premise of ensuring data information security is of great significance for improving data utilization and processing timeliness. [0003] At present, most enterprises use database users to control data access, that is, assign database accounts to perform addition, deletion, modification, and query operations on designated database instances. This method, on the one hand, relies too much on the database'...

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/62
CPCG06F21/6227G06F2221/2141
Inventor 张文翰孙丽娜彭金胜沈梦婷
Owner INDUSTRIAL AND COMMERCIAL BANK OF CHINA
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap