Database authority management method and device

A rights management and database technology, applied in the computer field, can solve the problems of low database management efficiency, and achieve the effect of simplifying the database access process, reducing the time used, and improving efficiency.

Active Publication Date: 2019-10-01
HUAWEI TECH CO LTD
View PDF5 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] Embodiments of the present application provide a database authority management method and equipment to solve the technical problem of low management efficiency of database authority in the database system

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
  • Database authority management method and device
  • Database authority management method and device
  • Database authority management method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0049] Hereinafter, the terms "first" and "second" are used for descriptive purposes only, and cannot be understood as indicating or implying relative importance or implicitly specifying the quantity of indicated technical features. Thus, a feature defined as "first" and "second" may explicitly or implicitly include one or more of these features. In the description of the embodiments of the present application, unless otherwise specified, "plurality" means two or more.

[0050] First, the terms in the embodiments of this application are introduced:

[0051] Metadata: Information describing the attributes of data. The metadata of the data table is the information describing the properties of the data table. Exemplarily, the metadata of the data table includes the name of the data table, the data structure of the data table, the storage location of the data table, and the historical data in the data table.

[0052] Role: A user with the same permissions. In this embodiment o...

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 database authority management method and device, and relates to the technical field of communication. The database authority management method is applied to authority management equipment. The authority management equipment is connected with at least one database, wherein at least one logical entity and access authorities of different users to each logical entity are set in the authority management equipment; and each logical entity corresponds to at least two data tables of the same type, and the description information of each logical entity comprises the type of thecorresponding data table and the identification of the database to which each corresponding data table belongs. The database authority management method comprises the following steps: the authority management equipment acquires metadata of a data table in a connected database; and then, the authority management equipment determines a target logic entity corresponding to the data table according to the metadata of the data table, then, the authority management equipment determines the access authority of the user to the target logic entity, and configures the access authority of the user to the data table in the database to which the data table belongs according to the access authority of the user to the target logic entity.

Description

technical field [0001] The present application relates to the field of computer technology, in particular to a method and device for managing database authority. Background technique [0002] In the existing database management system (Data Base Management System, DBMS), administrators need to manually create accounts and assign roles for operators (ie, ordinary users) who need to access the database in each database, and manually create accounts for each role. Configure the data tables that this role can authorize to access. That is, administrators need to manually create and maintain the following two correspondences locally in each database: the association between accounts and roles, and the authorization relationship between roles and data tables. For example, employee David needs to access the product table and customer order table stored in the Oracle database, as well as the call detail table stored in the Teradata database. Then, the administrator needs to create ...

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/6218
Inventor 朱蓉俊吴德港谢云鹏
Owner HUAWEI 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