Authority management method and apparatus

A permission management and permission technology, applied in the database field, can solve problems such as not having column-level permission management functions

Active Publication Date: 2019-01-04
NEW H3C BIG DATA TECH CO LTD
View PDF7 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In related technologies, SparkSQL does not have column-level permission management function

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
  • Authority management method and apparatus
  • Authority management method and apparatus
  • Authority management method and apparatus

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0019] Various exemplary embodiments, features, and aspects of the present disclosure will be described in detail below with reference to the accompanying drawings. The same reference numbers in the figures indicate functionally identical or similar elements. While various aspects of the embodiments are shown in drawings, the drawings are not necessarily drawn to scale unless specifically indicated.

[0020] The word "exemplary" is used exclusively herein to mean "serving as an example, embodiment, or illustration." Any embodiment described herein as "exemplary" is not necessarily to be construed as superior or better than other embodiments.

[0021] In addition, in order to better illustrate the present disclosure, numerous specific details are given in the following specific implementation manners. It will be understood by those skilled in the art that the present disclosure may be practiced without some of the specific details. In some instances, methods, means, componen...

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 present disclosure relates to an authority management method and apparatus, including obtaining authorization information from a received authorization SQL statement; adding a right record generated according to the authorization information to a column right data table of a metadata database when the authorization information includes a column identifier, and adding a right record generated according to the authorization information to a table right data table of the metadata database when the authorization information does not include a column identifier; when the access SQL statement isreceived, table-level authority verification being performed on the access SQL statement according to the authority record in the table authority data table, and column-level authority verification being performed on the access SQL statement according to the authority record in the column authority data table when the table-level authority verification is not passed. By performing permission verification according to the column-level permission data table and the table-level permission data table, the right management method and the device according to the disclosed embodiment can realize fine-grained right management in SparkSQL.

Description

technical field [0001] The present disclosure relates to the technical field of databases, in particular to a rights management method and device. Background technique [0002] Spark is a big data computing framework based on memory computing. It provides distributed computing functions, reads distributed stored data, and distributes tasks to each node for computing. Spark improves the real-time performance of data processing in a big data environment, while ensuring high fault tolerance and high scalability, allowing users to deploy Spark on a large number of cheap hardware to form a cluster. [0003] SparkSQL is a Spark-based distributed SQL (Structured Query Language) engine that supports SQL statements, which greatly facilitates users who are familiar with relational databases. [0004] Rights management refers to the security rules or security policies set according to the system. In the operation of the database, only authorized users can operate the database, and or...

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): G06F16/21G06F16/28G06F21/62
CPCG06F21/6218
Inventor 谷宁波户蕾蕾崔振凯
Owner NEW H3C BIG DATA 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