Unlock instant, AI-driven research and patent intelligence for your innovation.

Method and system used for refining database authority

A technology of database and permissions, applied in the field of database management, can solve problems such as difficulty in maintaining database data security, inability to authorize configuration, etc., and achieve the effect of improving security and finely controlling permissions

Inactive Publication Date: 2018-07-20
石化盈科信息技术有限责任公司
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

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and system used for refining database authority
  • Method and system used for refining database authority

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
IPC IPC(8): G06F21/62
CPCG06F21/6227G06F2221/2141
Inventor 赖秋严龙云
Owner 石化盈科信息技术有限责任公司