Method and system used for refining database authority

一种数据库、权限的技术，应用在数据库管理领域，能够解决维护数据库数据安全性困难、不能授权配置等问题，达到提高安全性、细控制权限的效果

Inactive Publication Date: 2018-07-20
PETRO-CYBERWORKS INFORMATION TECH CO LTD
View PDF4 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, it is impossible to perform authorization configuration for the dimensions such as tables and fields in the database at a deeper level, which brings great inconvenience to the database administrator and brings great difficulties to maintaining database data security.

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

Examples

Experimental program
Comparison scheme
Effect test

no. 1 example

[0063] Such as figure 1 Shown is a flowchart of a method for refining database permissions according to an embodiment of the present invention, the following reference figure 1 The present invention will be described in detail.

[0064] The first is step S110, establishing a data source table according to the configuration information of the database that needs to refine the authority.

[0065] Specifically, a data source table is established according to configuration information such as database type, database ID, database connection address, port, database user name, and database password of the database for which permissions need to be refined. Wherein, the connection information in the configuration information includes database connection address, port, database user name and database password. According to the storage model, the database types include Oracle, MySQL, SQLServer, etc. The database ID is the database name, which can be named when the database is created....

no. 2 example

[0085] According to another aspect of the present invention, a system for refining database permissions is also provided, such as figure 2 Shown is a system structure diagram for refining database permissions according to an embodiment of the present invention, the following reference figure 2 The present invention will be described in detail.

[0086] Such as figure 2 As shown, the system includes a data source table building module, a resource table building module, a user table building module and a user resource table building module. Wherein, the data source table establishing module is configured to establish the data source table according to the configuration information of the database that needs to refine the authority.

[0087] Specifically, a data source table is established according to configuration information such as database type, database ID, database connection address, port, database user name, and database password of the database for which permission...

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 method and a system used for refining database authority. The method includes: establishing a data source table according to configuration information of a database of which the authority needs to be refined; acquiring database name information and table information and field information in the database from the configuration information to establish a resource table; creating accessing users, and storing accessing-user information to establish a user table; and establishing relationships of the accessing users and resources in the resource table according to the accessing users and the resources in the resource table, and carrying out storing to establish a user resource relationship table. According to the method, finer control authority can be realized for the database, and security of the database is improved.

Description

technical field [0001] The invention belongs to the technical field of database management, and in particular relates to a method and system for refining database authority. Background technique [0002] With the continuous development of the IT industry, it is inevitable that the database connection information will be exposed to technical and business personnel during the entire project development process. Because the above-mentioned operators have too much authority to operate the database, they may misuse the data in the database, which will lead to data loss, and even cause the entire system to go down due to data problems. [0003] At present, in various database permission design schemes, the control of permissions is limited to read and write operations, and no deeper authorization control is performed on the database, such as controlling tables or fields in the database. Therefore, as an effective way to solve the above problem, the refined database permission tec...

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 PETRO-CYBERWORKS INFORMATION TECH CO LTD
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