Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method and equipment for setting row and column permissions of database

A data permission and database technology, applied in the field of data processing, can solve the problems of repeated permission control and reduce the flexibility of data access, so as to achieve the effect of improving security and flexibility

Pending Publication Date: 2022-08-02
上海柯林布瑞信息技术有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, in the process of employee management, the work contents of employees with different responsibilities and positions are different. Correspondingly, the access rights to various data also need to be set accordingly.
However, the entire process of data permission configuration and modification in the prior art has the problem of repeated permission control, which reduces the flexibility of data access

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 equipment for setting row and column permissions of database
  • Method and equipment for setting row and column permissions of database
  • Method and equipment for setting row and column permissions of database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0048] figure 1 This is a flowchart of a method for setting database row and column authority provided in Embodiment 1 of the present invention, and this embodiment can be applied to the situation of configuring data operation authority for data in a database. The method can be executed by a device for setting database row and column permissions, and the device can be implemented by software and / or hardware.

[0049]Before introducing the technical solutions of the embodiments of the present invention, the application scenarios for implementing the technical solutions of the present embodiments are exemplarily introduced. Of course, the following application scenarios are only optional application scenarios, and this embodiment may also be implemented in other application scenarios, and this embodiment does not limit the application scenarios of the implemented technical method. Specifically, in order to ensure the data security of the data in the database during the access o...

Embodiment 2

[0079] image 3 This is a flowchart of a method for setting database row and column permissions provided by Embodiment 2 of the present invention. On the basis of the above embodiments, this embodiment, optionally, is to perform a method for setting row and column permissions in a target data set according to each data permission configuration condition. After the data and / or column data is configured with the corresponding data operation authority, it also includes:

[0080] receiving a data operation request sent by a user through a data interface, wherein the data operation request is used to perform a data operation request on at least one data in the target data set;

[0081] Perform user authentication on the data operation request based on the user ID in the data operation request;

[0082] In the case that the user authentication is passed, perform data operation authority verification on the data operation request based on the data operation request identifier in the...

Embodiment 3

[0097] Figure 4 This is a schematic structural diagram of an apparatus for setting database row and column authority provided in Embodiment 3 of the present invention, and this embodiment can be applied to the situation of configuring data operation authority for data in a database. see Figure 4 , the specific structure of the database row and column authority setting device includes: a target data set generation module 310 and a data operation authority configuration module 320; wherein,

[0098] A target data set generation module 310, configured to obtain an initial data set of operation rights to be configured and various metadata of the initial data set, and generate a target data set of operation rights to be configured based on the metadata and the initial data set;

[0099] The data operation authority configuration module 320 is configured to obtain at least one data authority configuration condition, and configure corresponding data operation authority for row dat...

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 embodiment of the invention discloses a database row and column permission setting method and device. The method comprises the steps of obtaining an initial data set to be configured with an operation authority and metadata of the initial data set, and generating a target data set to be configured with the operation authority based on the metadata and the initial data set; and obtaining at least one data permission configuration condition, and configuring corresponding data operation permissions for row data and / or column data in the target data set according to the data permission configuration conditions. Through the technical scheme disclosed by the embodiment of the invention, the data operation authority in the database is flexibly controlled, and the security and flexibility of data storage and data access are improved.

Description

technical field [0001] Embodiments of the present invention relate to the technical field of data processing, and in particular, to a method and device for setting database row and column permissions. Background technique [0002] The informatization of enterprises can help enterprises have better prospects in the future development process, and the most important thing is to greatly improve the work efficiency of enterprise personnel. However, in the process of employee management, the work content of employees with different responsibilities and positions is different, and accordingly, the access rights to various types of data need to be set accordingly. However, the entire process of configuring and modifying data rights in the prior art has the problem of repeated rights control, which reduces the flexibility of data access. SUMMARY OF THE INVENTION [0003] The invention provides a method and device for setting database row and column authority, so as to realize fle...

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/60G06F16/21G06F16/2455
CPCG06F21/604G06F16/21G06F16/24553
Inventor 刘新辉黄主斌
Owner 上海柯林布瑞信息技术有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com