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

Row and column permission setting method and device applied to data access

A data access and data permission technology, applied in the field of data processing, can solve the problem of low flexibility of data access permission control, and achieve the effect of reducing control granularity and improving flexibility

Pending Publication Date: 2022-01-14
SHENZHEN COMTOP INFORMATION TECH
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, at present, data access permissions are usually controlled based on the data table level, that is, the granularity of permissions can only reach the data table level. Only when all the data in the data table is open to the user, the user has data access to the data table. Permissions, resulting in relatively low flexibility in data access control

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
  • Row and column permission setting method and device applied to data access
  • Row and column permission setting method and device applied to data access
  • Row and column permission setting method and device applied to data access

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0077] see figure 1 , figure 1 It is a schematic flowchart of a row and column permission setting method applied to data access disclosed by the embodiment of the present invention. in, figure 1 The described row and column permission setting method applied to data access can be applied to the data permission control of public systems, and can also be applied to the data permission control of internal systems of schools, enterprises, governments, and social organizations, which is not limited by the embodiments of the present invention. like figure 1 As shown, the row and column permission setting method applied to data access may include the following operations:

[0078] 101. Create data permissions corresponding to the data sets that need to be accessed, wherein the data permissions include at least one of data row-level permissions and data column-level permissions.

[0079] Among them, the data set can be a one-dimensional or multi-dimensional data set, and the data s...

Embodiment 2

[0129] see figure 2 , figure 2 It is a schematic flowchart of a row and column permission setting method applied to data access disclosed by the embodiment of the present invention. in, figure 2 The described row and column permission setting method applied to data access can be applied to the data permission control of public systems, and can also be applied to the data permission control of internal systems of schools, enterprises, governments, and social organizations, which is not limited by the embodiments of the present invention. like figure 2 As shown, the row and column permission setting method applied to data access may include the following operations:

[0130] 201. Create data permissions corresponding to the data sets that need to be accessed, wherein the data permissions include at least one of data row-level permissions and data column-level permissions;

[0131] 202. Determine a user role corresponding to the data permission.

[0132] 203. Configure d...

Embodiment 3

[0173] see image 3 , image 3 It is a structural schematic diagram of a row and column authority setting device applied to data access disclosed by the embodiment of the present invention. image 3 The described row and column permission setting device applied to data access can be used to realize data permission control of public systems, and can also be used to realize data permission control of internal systems of schools, enterprises, governments, and social organizations. Embodiments of the present invention do not limited. like image 3 As shown, the row and column permission setting device applied to data access can include:

[0174] The creation module 301 is used to create data permissions corresponding to the data sets that need to be accessed, wherein the data permissions include at least one of data row-level permissions and data column-level permissions.

[0175] The determination module 302 is configured to determine a user role corresponding to the data per...

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 discloses a row and column permission setting method and device applied to data access, and the method comprises the steps: creating a data permission corresponding to a data set needing to be accessed, the data permission comprising at least one of a data row level permission and a data column level permission; and determining a user role corresponding to the data permission, and configuring the data permission for the user role. Therefore, by implementing the method and the device, the data access authority control based on the row level and the column level can be realized, so that the control granularity of the data access authority control is reduced, and the flexibility of the data access authority control is improved.

Description

technical field [0001] The present invention relates to the technical field of data processing, in particular to a method and device for realizing dynamic row and column authority control on data models in a BI system. Background technique [0002] Due to the development of the times, data plays an extremely important role in people's work, study, and life. People can meet the needs of viewing data by accessing the data platform. The data is open to the user, so it is necessary to control the user's data access rights. [0003] Currently, according to the user's corresponding role (that is, the user category), the data access rights corresponding to the role can be configured for the user, and the user can only view the data for which the user has the corresponding data access rights. However, at present, data access permissions are usually controlled based on the data table level, that is, the granularity of permissions can only reach the data table level. Only when all th...

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/31
CPCG06F21/31
Inventor 罗珍明石刚杨赛杜祺曾文生张涛徐文娟徐倩云赵于权
Owner SHENZHEN COMTOP INFORMATION TECH