Automatic authorization access method for database

Abstract

The invention discloses an automatic authorization access method for a database. The automatic authorization access method is a method for automatically authorizing and accessing to the accessed database by an object required to be subjected to authorization access. The method comprises: step (S1), transmitting information of the accessed database as main library information; step (S2), according to the main library information, matching authorizable slave database information of a slave database corresponding to the accessed database in a preset main and slave database relation list; step (S3), according to the authorizable slave database information, executing an authorization statement in the accessed database to enable the slave database to be provided with an access right; step (S4), according to the authorizable slave database information, generating a data source accessed by the object required to be subjected to authorization access; step (S5), according to the data source, generating access configuration information accessed by the object required to be subjected to authorization access; and step (S6), according to the access configuration information, accessing to the accessed database by the object required to be subjected to authorization access.

Description

technical field [0001] The invention relates to a database authorization access method, in particular to a database automatic authorization access method. Background technique [0002] With the continuous development of database technology and network technology and the wide application of database management systems, the amount of data stored in databases has increased dramatically. In recent years, in the context of the development of information technology and data intelligence, data warehouse (DataWarehouse) technology for massive data storage and computing analysis for enterprise management and decision-making topics has been widely used. Among them, the security of the data warehouse is defined at the database level, and the establishment of access rights to the database is one of the strategies to protect data security, and it is also an effective guarantee for database security applications. [0003] In the process of extracting data from the database to the data wa...

AI Technical Summary

Problems solved by technology

[0005] In the existing database authorization access method, there are the following problems: (1) manual offline authorization needs to manually write database authorization statements, such as GRANT statements, etc., which is inefficient and prone to errors; In many cases, multiple authorizations need to be repeated; (3) The master-slave library relationship is not clear, if the production master library is directly extracted, it will affect normal production

(4) There is no verification of the connectivity process after authorization, and only when the actual data is extracted will the operation error be discovered and cause the online task to fail

Images