CN115577381B - Line-level data access method and device and electronic equipment - Google Patents

Line-level data access method and device and electronic equipment Download PDF

Info

Publication number
CN115577381B
CN115577381B CN202211576070.2A CN202211576070A CN115577381B CN 115577381 B CN115577381 B CN 115577381B CN 202211576070 A CN202211576070 A CN 202211576070A CN 115577381 B CN115577381 B CN 115577381B
Authority
CN
China
Prior art keywords
data
application
information
configuration
row
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN202211576070.2A
Other languages
Chinese (zh)
Other versions
CN115577381A (en
Inventor
许志远
吴海燕
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Yunli Intelligent Technology Co ltd
Original Assignee
Yunli Intelligent Technology Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Yunli Intelligent Technology Co ltd filed Critical Yunli Intelligent Technology Co ltd
Priority to CN202211576070.2A priority Critical patent/CN115577381B/en
Publication of CN115577381A publication Critical patent/CN115577381A/en
Application granted granted Critical
Publication of CN115577381B publication Critical patent/CN115577381B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F21/60—Protecting data
    • G06F21/604—Tools and structures for managing or administering access control systems
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
    • G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
    • G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
    • G06F3/0481—Interaction techniques based on graphical user interfaces [GUI] based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
    • G06F3/0482—Interaction with lists of selectable items, e.g. menus
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
    • G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
    • G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
    • G06F3/0484—Interaction techniques based on graphical user interfaces [GUI] for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
    • G06F3/04842—Selection of displayed objects or displayed text elements
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
    • Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • General Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Human Computer Interaction (AREA)
  • Bioethics (AREA)
  • Software Systems (AREA)
  • Computer Security & Cryptography (AREA)
  • Computer Hardware Design (AREA)
  • General Health & Medical Sciences (AREA)
  • Health & Medical Sciences (AREA)
  • Automation & Control Theory (AREA)
  • Storage Device Security (AREA)

Abstract

The invention provides a line-level data access method, a line-level data access device and electronic equipment, and relates to the technical field of data processing, wherein the method comprises the following steps: displaying a line-level data access application interface, wherein the interface comprises column field preview information and an application data configuration control; responding to configuration operation facing to the application data configuration control, determining data application information used for determining line-level data applied for access, and sending the data application information to server-side equipment, wherein the data application information comprises a target application field and a target data screening condition; and receiving authorization information generated under the condition that the approval result indicates that the approval is passed, wherein the authorization information is used for accessing the line-level data determined based on the data application information, and the approval result is determined based on the approval operation on the line-level authority approval interface provided by the server equipment. The technical scheme provided by the invention can improve the flexibility of row-level data management and control and access.

Description

Line-level data access method and device and electronic equipment
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a line-level data access method, an apparatus, and an electronic device.
Background
With the development of information technology and network technology, data resource sharing plays an increasingly important role, especially row-level data access is widely applied, and ensuring data security is also very important in data resource sharing.
In the related technology, in the row-level data authority control, a manager needs to set authorities for different row-level data of a data table in advance and allocate corresponding roles, and a user obtains the authority owned by the roles through the associated roles and then accesses the data allowed by the authorities. However, as time, organization architecture or business, etc. change continuously, management personnel need to frequently and massively modify authority configuration, data management and control are cumbersome, and flexibility is not high.
Disclosure of Invention
The invention provides a line-level data access method and device and electronic equipment, which aim to improve flexibility of line-level data management and control and access.
According to a first aspect of the present invention, there is provided a line level data access method, comprising:
displaying a line-level data access application interface, wherein the line-level data access application interface comprises column field preview information and an application data configuration control, and the column field preview information is used for guiding configuration operation executed in the application data configuration control;
responding to the configuration operation facing the application data configuration control, determining data application information, and sending the data application information to server-side equipment; the data application information comprises a target application field and a target data screening condition, and the data application information is used for determining row-level data for application access;
receiving authorization information sent by the server-side equipment, wherein the authorization information is generated by the server-side equipment under the condition that an approval result indicates that approval is passed, the approval result is determined based on approval operation on a line-level authority approval interface provided by the server-side equipment, and the data application information is displayed in the line-level authority approval interface; the authorization information is used to access row level data determined based on the data application information.
According to the line-level data access method provided by the invention, the application data configuration control comprises a column field configuration control and a configuration mode selection control; the determining data application information in response to the configuration operation facing the application data configuration control comprises:
responding to the selection operation facing the configuration mode selection control, determining the configuration mode of the data screening condition, and displaying the screening condition configuration control corresponding to the configuration mode;
responding to the configuration operation facing the screening condition configuration control, and determining the target data screening condition;
and determining the target application field in response to the configuration operation facing the column field configuration control.
According to the line-level data access method provided by the invention, the step of responding to the selection operation facing the configuration mode selection control, determining the configuration mode of the data screening condition and displaying the screening condition configuration control corresponding to the configuration mode comprises the following steps:
responding to a first operation of selecting a preset configuration mode by the configuration mode selection control, and determining that the configuration mode of the data screening condition is the preset configuration mode;
displaying a first screening condition configuration control corresponding to the preset configuration mode, wherein the first screening condition configuration control comprises a screening logic selection control and a screening reference value input control corresponding to the screening logic selection control;
the determining the target data screening condition in response to the configuration operation facing the screening condition configuration control comprises:
responding to the selection operation facing the selection control of the screening logic, and determining the screening logic;
responding to the input operation facing the screening reference value input control, and determining a screening reference value;
and generating the screening logic and the screening reference value as the target data screening condition.
According to the line-level data access method provided by the invention, the step of responding to the selection operation facing the configuration mode selection control, determining the configuration mode of the data screening condition and displaying the screening condition configuration control corresponding to the configuration mode comprises the following steps:
responding to a second operation of selecting a custom mode facing the configuration mode selection control, and determining that the configuration mode of the data screening condition is the custom mode;
and displaying a second screening condition configuration control corresponding to the user-defined mode, wherein the second screening condition configuration control is used for inputting user-defined screening conditions, and the screening conditions comprise regular expressions.
According to the line-level data access method provided by the invention, the line-level data access application display interface comprises the following steps:
in response to detecting a selection instruction of a selected target access data table, determining a target access data table;
and displaying a line-level data access application interface corresponding to the target access data table.
According to a second aspect of the present invention, there is provided a line level data access method, comprising:
receiving data application information sent by client equipment, wherein the data application information comprises a target application field and a target data screening condition;
displaying the data application information on a line-level authority approval interface, wherein the line-level authority approval interface also comprises an access approval control;
responding to the approval operation facing the access approval control, and determining the approval result of the data application information;
generating authorization information under the condition that the approval result indicates that the data application information is approved, and sending the authorization information to the client equipment; the authorization information is used for accessing row-level data determined based on the data application information;
the data application information is determined by the client device based on the detected configuration operation of an application data configuration control in the row-level-oriented data access application interface, the client device is used for displaying the row-level data access application interface, the row-level data access application interface further comprises column field preview information, and the column field preview information is used for guiding the configuration operation executed in the application data configuration control.
According to a third aspect of the present invention, there is provided a row-level data access apparatus comprising:
the device comprises a first display module, a second display module and a third display module, wherein the first display module is used for displaying a line-level data access application interface, the line-level data access application interface comprises column field preview information and an application data configuration control, and the column field preview information is used for indicating configuration operation executed in the application data configuration control;
the first determining module is used for responding to configuration operation facing the application data configuration control and determining data application information, wherein the data application information comprises a target application field and a target data screening condition, and the data application information is used for determining row-level data of application access;
the first sending module is used for sending the data application information to the server-side equipment;
the first receiving module is used for receiving authorization information sent by the server-side equipment, wherein the authorization information is generated by the server-side equipment under the condition that an approval result indicates that approval is passed, the approval result is determined based on approval operation on a row-level authority approval interface provided by the server-side equipment, and the data application information is displayed in the row-level authority approval interface; the authorization information is used to access row level data determined based on the data application information.
According to a fourth aspect of the present invention, there is provided a row level data access apparatus comprising:
the second receiving module is used for receiving data application information sent by the client equipment, wherein the data application information comprises a target application field and a target data screening condition;
the second display module is used for displaying the data application information on a horizontal authority approval interface, and the horizontal authority approval interface further comprises an access approval control;
the second determination module is used for responding to the approval operation facing the access approval control and determining the approval result of the data application information;
the generation module is used for generating authorization information under the condition that the approval result indicates that the data application information is approved, wherein the authorization information is used for accessing the row-level data determined based on the data application information;
a second sending module, configured to send the authorization information to the client device;
the data application information is determined by the client device based on detected configuration operation of an application data configuration control facing a row-level data access application interface, the client device is used for displaying the row-level data access application interface, the row-level data access application interface further comprises column field preview information, and the column field preview information is used for guiding the configuration operation executed in the application data configuration control.
According to a fifth aspect of the present invention, there is provided an electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the line-level data access method according to any one of the first aspect or the second aspect when executing the computer program.
The present invention also provides a computer-readable storage medium having stored thereon a computer program which, when executed by a processor, implements a line-level data access method as defined in any one of the above-mentioned first aspects, or implements a line-level data access method as defined in the above-mentioned second aspect.
The present invention also provides a computer program product comprising a computer program which, when executed by a processor, implements a method of line level data access as defined in any one of the above-mentioned first aspects, or implements a method of line level data access as defined in the above-mentioned second aspect.
The row-level data access method, the device and the electronic equipment provided by the invention provide a row-level data access application interface for applying for accessing row-level data for a user, column field preview information is displayed in the row-level data access application interface, an application data configuration control is provided, the application user can configure data application information in the application data configuration control according to the column field preview information, and the data application information can comprise a target application field and a target data screening condition so as to determine the row-level data required to be applied for accessing; the data application information is sent to the server-side equipment and displayed on a row-level authority approval interface provided by the server-side equipment, an approval person can execute approval operation on the row-level authority approval interface according to the data application information, the server-side equipment can generate authorization information under the condition that an approval result determined by the approval operation indicates that approval is passed, the authorization information is returned to an application user, the application user obtains access authority of row-level data corresponding to the data application information, and then access can be performed on the row-level data applied for access according to the authorization information. Therefore, the application user can actively apply for the required row-level data, the access authority of the row-level data applied for access can be obtained after the approval is passed, the administrator does not need to allocate fixed authorities to different roles in advance, and the method is also applicable to scenes where the authorities cannot be allocated in advance, so that the flexibility of row-level data management and control and access is improved.
Drawings
In order to more clearly illustrate the technical solutions of the present invention or the prior art, the drawings needed for the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and those skilled in the art can also obtain other drawings according to the drawings without creative efforts.
Fig. 1 is one of the flow diagrams of a row-level data access method provided in the embodiment of the present invention;
FIG. 2 is one of the schematic diagrams of a row level data access application interface in an embodiment of the invention;
FIG. 3 is a second schematic diagram of a row-level data access application interface in an embodiment of the present invention;
FIG. 4 is a second flowchart illustrating a row-level data access method according to an embodiment of the present invention;
FIG. 5 is a diagram of a row-level permission approval interface in an embodiment of the invention;
FIG. 6 is a schematic diagram of an approval result notification interface in an embodiment of the present invention;
FIG. 7 is a schematic structural diagram of a row-level data access device according to an embodiment of the present invention;
FIG. 8 is a second schematic diagram of a row-level data access apparatus according to an embodiment of the present invention;
fig. 9 is a schematic structural diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention clearer, the technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings, and it is obvious that the described embodiments are some, but not all embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It should be noted that the serial numbers themselves, such as "first", "second", and the like, for the components or the objects in the embodiments of the present invention are only used for distinguishing the described objects, and do not have any sequence or technical meaning.
In data sharing, the data access safety can be improved and data leakage is avoided by setting the authority for the data. Among them, the control of row-level data authority is widely applied in data sharing. In the related technology, the corresponding relation between different row-level data authorities of the data table and different roles can be pre-established in a white list mode, that is, the different row-level data authorities are allocated to corresponding roles, and after a user associates the roles, the row-level data authorities owned by the associated roles can be automatically acquired.
However, the row-level data authority of each data table owned by the user usually changes with internal and external factors such as time, position, organization or business, and is not fixed. This requires frequent and extensive modification of the authority configuration by data management personnel, which is cumbersome to operate and prone to the situation of untimely authority update. In addition, in some application scenarios, the row-level data permission of the user may not have a clear standard, and it is difficult to allocate the permission in advance, and the permission often needs to be flexibly configured according to actual conditions, so that the requirement of the data permission cannot be met through the implementation manner of allocating the permission in advance by an administrator.
Based on this, the embodiment of the present invention provides a row-level data access method, which may provide a row-level data access application interface for a user to apply for accessing row-level data, display column field preview information in the row-level data access application interface, and provide an application data configuration control, where the column field preview information may instruct the application user to configure data application information in the application data configuration control, and the data application information may include a target application field and a target data screening condition, so as to determine row-level data that needs to apply for access; the data application information is sent to the server-side equipment and displayed on a row-level authority approval interface provided by the server-side equipment, the server-side equipment can respond to approval operation of an approver on the row-level authority approval interface, authorization information is generated under the condition that an approval result determined by the approval operation indicates that the approval is passed, the authorization information is returned to an application user, the application user obtains access authority of row-level data corresponding to the data application information, and then access can be carried out on the row-level data applied for access according to the authorization information.
The line level data access method of the present invention is described below in conjunction with fig. 1-5.
Fig. 1 illustrates one of the flow diagrams of the line-level data access method provided by the embodiment of the present invention, where the line-level data access method may be applied to a client device, and may also be applied to a line-level data access apparatus provided in the client device, where the line-level data access apparatus may be implemented by software, hardware, or a combination of the two; the client device may be an electronic device such as a mobile phone and a computer. Referring to fig. 1, the row-level data access method may include the following steps 110 to 140.
Step 110: and displaying a line-level data access application interface.
The row-level data access application interface can comprise column field preview information and application data configuration control. The column field preview information may be used to guide a configuration operation performed in the application data configuration control. For example, column field preview information may show column field information in an accessed data table, such as field names, field types, field description information, and the like contained in the data table, to an applying user, and the column field preview information may help the applying user to know basic field information of the accessed data table, so as to guide the applying user to perform targeted configuration in an applying data configuration control, indicate fields allowed to be configured, data formats that can be accepted, and the like.
For example, basic information of the accessed data table, such as at least one of name, provider, manager, update time, data amount, sharing times, etc., may be displayed in the row-level data access application interface, but is not limited thereto.
Step 120: and determining data application information in response to configuration operation of the application data configuration control in the row-level-oriented data access application interface.
The application data configuration control can be used for configuring data application information, the data application information can comprise a target application field and a target data screening condition, and the data application information can be used for determining row-level data for application access.
Specifically, the application user can select a column field to be accessed from the column fields displayed by the column field preview information, and configure a target application field by inputting or selecting the column field to be accessed through the application data configuration control; and meanwhile, target data screening conditions corresponding to the column fields can be configured through the application data configuration control, and the target data screening conditions can be used for screening the column data indicated by the configured target application fields to obtain row-level data of the row where the screened data in the column data is located. Therefore, based on the configuration operation on the application data configuration control, the data application information can be determined, and the target application field and the target data screening condition are obtained.
Step 130: and sending the data application information to the server-side equipment.
After the application user configures the data application information through the application data configuration control, the application user can submit the application access, for example, click an "application" control in a row-level data access application interface, and the client device responds to the click operation and can send the configured data application information to the server device to request to access the row-level data indicated by the data application information.
Step 140: and receiving the authorization information sent by the server side equipment.
The authorization information is generated by the server device under the condition that the approval result indicates that the approval is passed, the authorization information can be used for accessing the row-level data determined based on the data application information, and after the client device obtains the authorization information, the client device obtains the access authority of the row-level data indicated by the data application information and can access the corresponding row-level data based on the authorization information.
For example, the authorization information may be AKSK (access key secretekey) information, where AK (access key) is used to identify the user and SK (secretekey) is a key, which may be used to encrypt the authentication string and verify the authentication string. Based on the AKSK information, the application user can access row-level data indicated by the data application information in the data table in a token (token) mode.
The approval result is determined based on the approval operation on the line-level authority approval interface provided by the server device, and the sent data application information can be displayed in the line-level authority approval interface so as to be previewed by a management user of the server device, and accordingly, the approval operation is executed on the line-level authority approval interface.
The line-level data access method provided by the invention can provide a line-level data access application interface for applying for accessing line-level data for a user, column field preview information is displayed in the line-level data access application interface, an application data configuration control is provided, the application user can configure data application information in the application data configuration control according to the column field preview information, and the data application information can comprise a target application field and a target data screening condition so as to determine the line-level data to be applied for accessing; the data application information is sent to the server-side equipment and displayed on a row-level authority approval interface provided by the server-side equipment, an approval person can execute approval operation on the row-level authority approval interface according to the data application information, the server-side equipment can generate authorization information under the condition that an approval result determined by the approval operation indicates that approval is passed, the authorization information is returned to an application user, the application user obtains access authority of row-level data corresponding to the data application information, and then access can be performed on the row-level data which is applied for access according to the authorization information. Therefore, the application user can actively apply for the required row-level data, the access authority of the row-level data applied for access can be obtained after the approval is passed, the administrator does not need to allocate fixed authorities to different roles in advance, and the method is also applicable to scenes where the authorities cannot be allocated in advance, so that the flexibility of row-level data management and control and access is improved.
Based on the row-level data access method of the embodiment corresponding to fig. 1, in an example embodiment, the application data configuration control may include a column field configuration control and a configuration mode selection control; in response to the configuration operation of the application data configuration control, determining data application information may include: responding to the selection operation of the configuration mode selection control, determining the configuration mode of the data screening condition, and displaying the screening condition configuration control corresponding to the configuration mode; responding to the configuration operation of the configuration control facing the screening condition, and determining a target data screening condition; and determining the target application field in response to the configuration operation of the column-oriented field configuration control.
For example, fig. 2 exemplarily shows one of schematic diagrams of a row-level data access application interface in an embodiment of the present invention, and referring to fig. 2, in the interface, data table base information, column field preview information, and application data configuration control may be presented. The data table basic information may include information such as a name of the data table, a provider, a manager, update time, data amount, and sharing times, where the name may include a chinese name and an english name. The column field preview information may show column field information of the accessed data table in a form of a table, for example, the column field information may include field names, field types, field descriptions, and the like, wherein the field names may include field Chinese names and field English names, for example; the field type may indicate the data type of the field; the field description may be used to interpret the field. The application data configuration control may include a column field configuration control, a configuration mode selection control, and a screening condition configuration control corresponding to a configuration mode selected in the configuration mode selection control.
The application user can input the names of the column fields needing to be accessed in the optional column fields through the column field configuration control according to the optional column fields displayed by the column field preview information, and the client device can determine the target application fields based on the configuration operation. An application user can select a configuration mode of the screening condition through the configuration mode selection control, for example, a 'preset configuration mode' is selected through a pull-down menu of the configuration mode selection control, a screening logic selection control and a screening reference value input control corresponding to the 'preset configuration mode' can be displayed in a row-level data access application interface, the application user can select the screening logic through the screening logic selection control, a screening reference value of the screening logic is set through the screening reference value input control (corresponding to 'please fill in the screening reference value' in fig. 2), and the client device can determine the target data screening condition based on the configuration operations. After configuration is completed, an application user can click the application control to submit an access application, and the client device can send data application information determined based on the configuration operations to the server device to apply line-level data required to be accessed to the server device. Illustratively, the data application information may further include identity information of the application user.
Based on this, for example, in an embodiment, in response to a selection operation of the configuration-oriented selection control, determining a configuration manner of the data filtering condition, and displaying a filtering condition configuration control corresponding to the configuration manner, may include: responding to a first operation of selecting a preset configuration mode by a configuration mode selection control, and determining that the configuration mode of the data screening condition is the preset configuration mode; and displaying a first screening condition configuration control corresponding to the preset configuration mode, wherein the first screening condition configuration control comprises a screening logic selection control and a screening reference value input control corresponding to the screening logic selection control. Correspondingly, the determining the target data screening condition in response to the configuration operation of the screening condition-oriented configuration control may include: responding to the selection operation of the selection control facing the screening logic, and determining the screening logic; responding to the input operation facing the screening reference value input control, and determining a screening reference value; and generating the screening logic and the screening reference value as the target data screening condition.
For example, in fig. 2, the application user selects a "preset configuration mode" through the pull-down menu of the configuration mode selection control, selects the screening logic as the conditional operation logic "greater than" through the screening logic selection control, and generates the target data screening condition "greater than 10" if the screening reference value input in the screening reference value input control is 10. And combining the target application field determined by the column field name input in the column field configuration control, generating data application information, wherein the data application information can indicate that an application user needs to access row data corresponding to data larger than 10 in the column data indicated by the target application field.
For example, in another embodiment, a function of customizing the filtering condition may also be provided for the application user. Specifically, in response to the selection operation of the configuration mode-oriented selection control, determining the configuration mode of the data screening condition, and displaying the screening condition configuration control corresponding to the configuration mode may include: responding to a second operation of selecting a custom mode by the configuration mode selection control, and determining that the configuration mode of the data screening condition is the custom mode; and displaying a second screening condition configuration control corresponding to the user-defined mode, wherein the second screening condition configuration control is used for inputting the user-defined screening conditions. Illustratively, the screening condition may include a regular expression.
For example, fig. 3 exemplarily shows a second schematic diagram of a row-level data access application interface in the embodiment of the present invention, as shown in fig. 3, an application user may select a configuration mode as a "custom mode" through a pull-down menu of a configuration mode selection control, and accordingly, a second screening condition configuration control corresponding to the "custom mode" may be displayed in the row-level data access application interface, that is, a control corresponding to the "screening condition configuration" in fig. 3, and the application user may input a screening condition in the control in a custom manner, for example, may write a regular expression or a where statement in the control, so as to obtain a target data screening condition.
Based on the above embodiments, in the embodiments of the present invention, an application user configures a screening condition of one column (one field) or multiple columns (multiple fields) of a data table in a row-level data access application interface to obtain a target data screening condition, row-level data in the data table that meets the target data screening condition is taken as an object for applying for access, and the application user submits an access application.
In the embodiment of the present invention, the configuration modes of the data screening conditions may include a preset configuration mode and a user-defined mode, and the application user may select one configuration mode to configure the data screening conditions. The screening logic of the data screening condition may include at least one of a conditional operation and a logical operation, the conditional operation may include at least one of greater than, less than, equal to, greater than or equal to, less than or equal to, and unequal to, and the like, and the logical operation may include at least one of logical or, and not. More complex data screening conditions can be realized through a custom regular expression or a custom where statement.
For example, whether the preset configuration mode or the custom mode is selected, the configured target data screening condition may be converted into a conditional Query statement of Structured Query Language (SQL), and corresponding row-level data is queried in the data table through the conditional Query statement.
Based on the line-level data access method in the corresponding embodiment of fig. 1, in an example embodiment, displaying a line-level data access application interface may include: in response to detecting a selection instruction of a selected target access data table, determining a target access data table; and displaying a row-level data access application interface corresponding to the target access data table.
For example, a data table selection interface may be displayed or a data table selection menu may be provided in the row-level data access application interface, at least one data table to be accessed may be included in the data table selection interface or the data table selection menu, and the application user may perform a selection operation to select one data table from the data tables to be accessed as a target access data table for accessing row-level data.
Based on the row-level data access method in the embodiment corresponding to fig. 1, fig. 4 exemplarily shows a second flowchart of the row-level data access method provided in the embodiment of the present invention, where the row-level data access method may be applied to a server device, and the server device may be, for example, a server, a backend platform, or the like. Referring to fig. 4, the line-level data access method may include the following steps 410 to 440.
Step 410: and receiving data application information sent by the client equipment.
The data application information may include a target application field and a target data screening condition, and the data application information may be used to determine line level data for application access. Specifically, row-level data meeting the target data screening condition can be screened from column data corresponding to the target application field in the data table.
The data application information is determined by the client device based on the detected configuration operation of the application data configuration control in the row-level-oriented data access application interface, the client device can also be used for displaying the row-level data access application interface, the row-level data access application interface further comprises column field preview information, and the column field preview information can be used for guiding the executable configuration operation in the application data configuration control.
Step 420: and displaying data application information on the line-level authority approval interface.
Step 430: and determining an approval result of the data application information in response to the approval operation of the access approval control in the row-level permission approval interface.
The row-level authority approval interface also comprises an access approval control, and the data application information can be approved or not approved through the access approval control.
Step 440: and generating authorization information under the condition that the approval result indicates that the data application information is approved, and sending the authorization information to the client equipment.
The authorization information may be used to access row level data determined based on the data application information. For example, the authorization information may be AKSK information.
For example, fig. 5 exemplarily shows a schematic diagram of a row-level permission approval interface in an embodiment of the present invention, and referring to fig. 5, information such as data table basic information, application data preview information, application details, and the like, and an access approval control may be presented in the row-level permission approval interface. The data table basic information may include information such as a name of the data table, an update time, a data amount, and a number of sharing times, where the name may include, for example, a chinese name and an english name. The application data preview information can display the row-level data screened out through the data application information in a form, for example, target application fields in the data application information include 'county region', 'first industry acceleration rate', 'second industry acceleration rate' and 'third industry acceleration rate', data meeting target data screening conditions can be screened out from columns where the target application fields are located in a data table, row data of rows where the column data are located are obtained, and the data are displayed in the form of the application data preview information, and auditors can preview the row-level data which are applied for access by application users through the form. The application detail information may include information such as identity information, application time, a matching manner, column fields, and screening conditions of the application user, where the matching manner corresponds to a configuration manner configured by the application user in the row-level data access application interface, the column fields correspond to the target application fields, and the screening conditions correspond to the target data screening conditions. Through the display of the application detail information, the examination and approval personnel can know the identity information of the application user and the details of the row-level data requested to be accessed, so that examination and approval operations which are approved or not approved can be made according to the ground.
The access approval control provides an approval pass or fail approval control, and an approval person can perform approval operation according to the approval pass or fail approval pass. Illustratively, accessing the approval control may further include an approval opinion input control inputting approval opinions through which an approver may fill in the approval opinions. When the approver selects 'pass' in the access approval control, after the determination, the server device can generate authorization information and send the authorization information to the client device of the application user, and the application user can access the row-level data to which access is applied based on the authorization information.
Based on the row-level data access method of each embodiment, the row-level data access method provided by the embodiment of the present invention is further exemplified by taking the row-level data applied for the user to access the data table shown in table 1 below as an example, and table 1 exemplarily shows the annual production total value information in a certain area.
TABLE 1
Figure 676826DEST_PATH_IMAGE001
As shown in table 1, the column field preview information formed by the column fields, and the data table basic information such as the name, provider, and update time of the data table may be presented in the row-level data access application interface shown in fig. 2, and when the application user accesses row-level data using the data table shown in table 1 as the target data table, the application user may apply in the row-level data access application interface shown in fig. 2.
For example, if the application user selects a "preset configuration mode" from the control corresponding to the "configuration mode", the field name input in the "column field" is the "total production value in per capita area", and the control corresponding to the "selection logic selection" is selected as "less than", and the filled-in selection reference value is "1000", then the target data selection condition "less than 1000" may be formed, after the application is submitted, the server device may select data less than 1000 from the column data corresponding to the "total production value in per capita area" in the data table shown in table 1, and the line data in which the selected data are located may form, for example, application data preview information shown in fig. 5, which is displayed on a line-level permission approval interface for an approver to preview. Specifically, in table 1, row-level data corresponding to city B, city C, city D, city E, and city I may be screened out, and may be displayed in a row-level permission approval interface in a table form. With reference to fig. 5, the approver may perform an approval operation in the access approval control based on the application data preview information, select "pass" or "fail", and complete the approval after clicking "determine".
If the approval result is that the approval data does not pass, the server-side equipment can send the prompt information that the approval does not pass to the client-side equipment of the application user, and the application user can not access the row-level data which is applied for access.
If the approval result is that the access request is passed, the server-side equipment can generate AKSK information and send the AKSK information to client-side equipment of the application user, the application user can obtain the authority of accessing the row-level data which is applied to be accessed after obtaining the AKSK information, and the row-level data which is applied to be accessed can be accessed in a token mode based on the AKSK information. For example, when the application user accesses the applied row-level data, the SQL query statement may be executed on the client device through the execution interface to obtain the data, and the server device may return the row-level data corresponding to the SQL query statement in the row-level data for obtaining the access right to the client device according to the SQL query statement.
For example, after the server device sends the AKSK information to the client device of the application user, the client device of the application user may display approval result notification information on an interface, for example, fig. 6 exemplarily shows a schematic diagram of an approval result notification interface in an embodiment of the present invention, referring to fig. 6, information such as application time, approval time, an approval state and the like may be displayed in the approval result notification interface, and when the approval state is that the approval is passed, authorization information such as a download control of the AKSK may be provided.
For example, by taking the row-level data with the total production value less than 1000 of the mans-district in table 1 as an example, the application user may configure the target data screening condition "less than 1000" in a customized manner. For example, in conjunction with fig. 3, the application user may input a field name "total production value per capita area" in the "column field", select a "custom mode" in the control corresponding to the "configuration mode", input a field name "total production value per capita area" in the "column field", and accordingly, fill a custom screening condition such as "[1-9] \ \ d {0,2} +" in the input control corresponding to the "screening condition configuration". Where'[ 1-9]' means that the first bit of the data can be any one of 1-9, and'd {0,2} +' means that one or two bits 0-9 can appear after the first bit. After clicking the application, the configured target data screening condition [1-9] \ \ d {0,2} + "and the target application field" total value of per capita area production "can be sent to the server device, and the server device is applied for accessing the corresponding row-level data.
The line-level data access method provided by the embodiment of the invention can be applied to scenes with frequently changed line-level data authorities and can also be applied to line-level authority control scenes without definite line-level authority standards and needing to be flexibly processed by specific personnel according to actual conditions. By the line-level data access method provided by the embodiment of the invention, an application user can actively apply for line-level data required to be accessed by the application user, and the access authority of the applied line-level data can be obtained after the application user passes the examination and approval.
The following describes the row-level data access apparatus provided by the present invention, and the row-level data access apparatus described below and the row-level data access method described above may be referred to in correspondence with each other.
Fig. 7 is a schematic diagram illustrating a structure of a row-level data access apparatus according to an embodiment of the present invention, and referring to fig. 7, the row-level data access apparatus 700 may include: the first display module 710 is configured to display a row-level data access application interface, where the row-level data access application interface includes column field preview information and an application data configuration control, and the column field preview information is used to guide a configuration operation executed in the application data configuration control; a first determining module 720, configured to determine data application information in response to a configuration operation of the application data configuration control, where the data application information includes a target application field and a target data screening condition, and the data application information is used to determine line-level data to which an application is applied for access; the first sending module 730 is configured to send the data application information to the server device; the first receiving module 740 is configured to receive authorization information sent by the server device, where the authorization information is generated when the server device indicates that the approval is passed according to the approval result, the approval result is determined based on an approval operation on a row-level permission approval interface provided by the server device, and data application information is displayed in the row-level permission approval interface; the authorization information is used to access row level data determined based on the data application information.
In an example embodiment, the application data configuration control includes a column field configuration control and a configuration mode selection control. The first determining module 720 may include: the first determining subunit is used for determining the configuration mode of the data screening condition in response to the selection operation of the configuration mode selection control and displaying the screening condition configuration control corresponding to the configuration mode; the second determining subunit is used for determining the target data screening condition in response to the configuration operation of the screening condition-oriented configuration control; and the third determining subunit is used for determining the target application field in response to the configuration operation of the column-oriented field configuration control.
In an example embodiment, the first determining subunit may be specifically configured to: responding to a first operation of selecting a preset configuration mode by a configuration mode selection control, and determining that the configuration mode of the data screening condition is the preset configuration mode; and displaying a first screening condition configuration control corresponding to the preset configuration mode, wherein the first screening condition configuration control comprises a screening logic selection control and a screening reference value input control corresponding to the screening logic selection control. The second determining subunit may be specifically configured to: responding to the selection operation of the selection control facing the screening logic, and determining the screening logic; responding to the input operation facing the screening reference value input control, and determining a screening reference value; and generating the screening logic and the screening reference value as the target data screening condition.
In an example embodiment, the first determining subunit may be specifically configured to: responding to a second operation of selecting a custom mode by the configuration mode selection control, and determining that the configuration mode of the data screening condition is the custom mode; and displaying a second screening condition configuration control corresponding to the custom mode, wherein the second screening condition configuration control is used for inputting the custom screening condition, and the screening condition comprises a regular expression.
In an example embodiment, the first display module 710 may include: the determining unit is used for responding to the detection of a selection instruction of the selected target access data table, and determining the target access data table; and the display unit is used for displaying the row-level data access application interface corresponding to the target access data table.
Fig. 8 illustrates a second schematic structural diagram of a row-level data access apparatus provided in an embodiment of the present invention, and referring to fig. 8, the row-level data access apparatus 800 may include: a second receiving module 810, configured to receive data application information sent by a client device, where the data application information includes a target application field and a target data screening condition; the second display module 820 is configured to display data application information on a row-level permission approval interface, where the row-level permission approval interface further includes an access approval control; the second determining module 830 is configured to determine an approval result of the data application information in response to an approval operation facing the access approval control; a generating module 840, configured to generate authorization information when the approval result indicates that the data application information is approved, where the authorization information is used to access the row-level data determined based on the data application information; a second sending module 850, configured to send the authorization information to the client device; the data application information is determined by client equipment based on detected configuration operation of an application data configuration control in a row-level-oriented data access application interface, the client equipment is used for displaying the row-level data access application interface, the row-level data access application interface further comprises column field preview information, and the column field preview information is used for guiding the configuration operation executed in the application data configuration control.
Fig. 9 illustrates a schematic structural diagram of an electronic device, which may include, as shown in fig. 9: a processor (processor) 910, a Communication Interface (Communication Interface) 920, a memory (memory) 930 and a Communication bus 940, wherein the processor 910, the Communication Interface 920 and the memory 930 are communicated with each other via the Communication bus 940. Processor 910 may invoke logic instructions in memory 930 to perform a line level data access method provided by any of the above method embodiments, which may include, for example: displaying a line-level data access application interface, wherein the line-level data access application interface comprises column field preview information and an application data configuration control, and the column field preview information is used for guiding configuration operation executed in the application data configuration control; responding to configuration operation facing to the application data configuration control, determining data application information, and sending the data application information to the server-side equipment; the data application information comprises a target application field and a target data screening condition, and the data application information is used for determining row-level data applied for access; receiving authorization information sent by server equipment, wherein the authorization information is generated by the server equipment under the condition that an approval result indicates that approval is passed, the approval result is determined based on approval operation on a line-level authority approval interface provided by the server equipment, and data application information is displayed in the line-level authority approval interface; the authorization information is used to access row level data determined based on the data application information.
Furthermore, the logic instructions in the memory 930 may be implemented in software functional units and stored in a computer readable storage medium when the logic instructions are sold or used as independent products. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.
In another aspect, the present invention also provides a computer program product, the computer program product including a computer program, the computer program being stored on a computer-readable storage medium, and when the computer program is executed by a processor, the computer is capable of executing the line-level data access method provided by the above-mentioned method embodiments, and the method may include: displaying a line-level data access application interface, wherein the line-level data access application interface comprises column field preview information and an application data configuration control, and the column field preview information is used for guiding configuration operation executed in the application data configuration control; responding to configuration operation facing to the application data configuration control, determining data application information, and sending the data application information to the server-side equipment; the data application information comprises a target application field and a target data screening condition, and the data application information is used for determining row-level data applied for access; receiving authorization information sent by server equipment, wherein the authorization information is generated by the server equipment under the condition that an approval result indicates that approval is passed, the approval result is determined based on approval operation on a line-level authority approval interface provided by the server equipment, and data application information is displayed in the line-level authority approval interface; the authorization information is used to access row level data determined based on the data application information.
In yet another aspect, the present invention also provides a computer-readable storage medium, on which a computer program is stored, the computer program being implemented by a processor to execute the line-level data access method provided by the above method embodiments, and the method may include: displaying a line-level data access application interface, wherein the line-level data access application interface comprises column field preview information and an application data configuration control, and the column field preview information is used for guiding configuration operation executed in the application data configuration control; responding to configuration operation facing to the application data configuration control, determining data application information, and sending the data application information to the server-side equipment; the data application information comprises a target application field and a target data screening condition, and the data application information is used for determining row-level data applied for access; receiving authorization information sent by server equipment, wherein the authorization information is generated by the server equipment under the condition that an approval result indicates that approval is passed, the approval result is determined based on approval operation on a line-level authority approval interface provided by the server equipment, and data application information is displayed in the line-level authority approval interface; the authorization information is used to access row level data determined based on the data application information.
The above-described embodiments of the apparatus are merely illustrative, and the units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one position, or may be distributed on multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment. One of ordinary skill in the art can understand and implement it without inventive effort.
Through the above description of the embodiments, those skilled in the art will clearly understand that each embodiment can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware. With this understanding in mind, the above-described technical solutions may be embodied in the form of a software product, which can be stored in a computer-readable storage medium such as ROM/RAM, magnetic disk, optical disk, etc., and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute the methods described in the embodiments or some parts of the embodiments.
Finally, it should be noted that: the above examples are only intended to illustrate the technical solution of the present invention, but not to limit it; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.

Claims (10)

1. A method for line level data access, comprising:
displaying a line-level data access application interface, wherein the line-level data access application interface comprises column field preview information and an application data configuration control, and the column field preview information is used for guiding configuration operation executed in the application data configuration control and indicating fields allowing configuration and acceptable data formats; the column field preview information shows column field information of the accessed data table in a form of a table, wherein the column field information comprises a field name, a field type and field description information;
responding to the configuration operation facing the application data configuration control, determining data application information, and sending the data application information to server-side equipment; the data application information comprises a target application field and a target data screening condition, and the data application information is used for determining row-level data applied for access;
receiving authorization information sent by the server-side equipment, wherein the authorization information is generated by the server-side equipment under the condition that an approval result indicates approval, the approval result is determined based on approval operation on a line-level authority approval interface provided by the server-side equipment, and the data application information is displayed in the line-level authority approval interface; the authorization information is used for accessing row level data determined based on the data application information.
2. The row level data access method according to claim 1, wherein the application data configuration control comprises a column field configuration control and a configuration mode selection control; the determining data application information in response to the configuration operation facing the application data configuration control comprises:
responding to the selection operation facing the configuration mode selection control, determining the configuration mode of the data screening condition, and displaying the screening condition configuration control corresponding to the configuration mode;
responding to the configuration operation facing the screening condition configuration control, and determining the target data screening condition;
and determining the target application field in response to the configuration operation facing the column field configuration control.
3. The method for accessing row-level data according to claim 2, wherein the determining the configuration of the data filtering condition in response to the selection operation facing the configuration selection control and displaying the filtering condition configuration control corresponding to the configuration comprises:
responding to a first operation of selecting a preset configuration mode facing the configuration mode selection control, and determining that the configuration mode of the data screening condition is the preset configuration mode;
displaying a first screening condition configuration control corresponding to the preset configuration mode, wherein the first screening condition configuration control comprises a screening logic selection control and a screening reference value input control corresponding to the screening logic selection control;
the determining the target data screening condition in response to the configuration operation facing the screening condition configuration control comprises:
responding to the selection operation facing the selection control of the screening logic, and determining the screening logic;
responding to the input operation facing the screening reference value input control, and determining a screening reference value;
and generating the screening logic and the screening reference value as the target data screening condition.
4. The method for accessing row-level data according to claim 2, wherein the determining the configuration mode of the data screening condition and displaying the screening condition configuration control corresponding to the configuration mode in response to the selection operation facing the configuration mode selection control comprises:
responding to a second operation of selecting a custom mode facing the configuration mode selection control, and determining that the configuration mode of the data screening condition is the custom mode;
and displaying a second screening condition configuration control corresponding to the user-defined mode, wherein the second screening condition configuration control is used for inputting user-defined screening conditions, and the screening conditions comprise regular expressions.
5. The method for line-level data access according to any one of claims 1 to 4, wherein the displaying of the line-level data access application interface comprises:
in response to detecting a selection instruction of a selected target access data table, determining a target access data table;
and displaying a row-level data access application interface corresponding to the target access data table.
6. A method for line level data access, comprising:
receiving data application information sent by client equipment, wherein the data application information comprises a target application field and a target data screening condition;
displaying the data application information on a line-level authority approval interface, wherein the line-level authority approval interface also comprises an access approval control;
responding to the approval operation facing the access approval control, and determining the approval result of the data application information;
generating authorization information under the condition that the approval result indicates that the data application information is approved, and sending the authorization information to the client equipment; the authorization information is used for accessing row-level data determined based on the data application information;
the data application information is determined by the client device based on the detected configuration operation of an application data configuration control in a row-level-oriented data access application interface, the client device is used for displaying the row-level data access application interface, the row-level data access application interface further comprises column field preview information, and the column field preview information is used for guiding the configuration operation executed in the application data configuration control, and indicates fields allowing configuration and acceptable data formats; the column field preview information presents column field information of the accessed data table in a table form, and the column field information comprises a field name, a field type and field description information.
7. A row level data access apparatus, comprising:
the system comprises a first display module, a second display module and a third display module, wherein the first display module is used for displaying a line-level data access application interface, the line-level data access application interface comprises column field preview information and an application data configuration control, the column field preview information is used for guiding configuration operation executed in the application data configuration control, and indicating fields allowing configuration and acceptable data formats; the column field preview information shows column field information of the accessed data table in a form of a table, wherein the column field information comprises a field name, a field type and field description information;
the first determining module is used for determining data application information in response to configuration operation facing the application data configuration control, wherein the data application information comprises a target application field and a target data screening condition, and the data application information is used for determining row-level data applied for access;
the first sending module is used for sending the data application information to the server-side equipment;
the first receiving module is used for receiving authorization information sent by the server-side equipment, wherein the authorization information is generated by the server-side equipment under the condition that an approval result indicates approval, the approval result is determined based on approval operation on a row-level authority approval interface provided by the server-side equipment, and the data application information is displayed in the row-level authority approval interface; the authorization information is used to access row level data determined based on the data application information.
8. A row level data access apparatus, comprising:
the second receiving module is used for receiving data application information sent by the client equipment, wherein the data application information comprises a target application field and a target data screening condition;
the second display module is used for displaying the data application information on a row-level authority approval interface, and the row-level authority approval interface further comprises an access approval control;
the second determining module is used for responding to the approval operation facing the access approval control and determining the approval result of the data application information;
the generating module is used for generating authorization information under the condition that the approval result indicates that the data application information is approved, wherein the authorization information is used for accessing row-level data determined based on the data application information;
a second sending module, configured to send the authorization information to the client device;
the data application information is determined by the client device based on the detected configuration operation of an application data configuration control in a row-level-oriented data access application interface, the client device is used for displaying the row-level data access application interface, the row-level data access application interface further comprises column field preview information, and the column field preview information is used for guiding the configuration operation executed in the application data configuration control, and indicates fields allowing configuration and acceptable data formats; the column field preview information presents column field information of the accessed data table in a table form, and the column field information comprises a field name, a field type and field description information.
9. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the line level data access method according to any one of claims 1 to 5 or implements the line level data access method according to claim 6 when executing the computer program.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the line-level data access method according to any one of claims 1 to 5, or carries out the line-level data access method according to claim 6.
CN202211576070.2A 2022-12-09 2022-12-09 Line-level data access method and device and electronic equipment Active CN115577381B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202211576070.2A CN115577381B (en) 2022-12-09 2022-12-09 Line-level data access method and device and electronic equipment

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202211576070.2A CN115577381B (en) 2022-12-09 2022-12-09 Line-level data access method and device and electronic equipment

Publications (2)

Publication Number Publication Date
CN115577381A CN115577381A (en) 2023-01-06
CN115577381B true CN115577381B (en) 2023-04-11

Family

ID=84590425

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202211576070.2A Active CN115577381B (en) 2022-12-09 2022-12-09 Line-level data access method and device and electronic equipment

Country Status (1)

Country Link
CN (1) CN115577381B (en)

Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107194272A (en) * 2017-04-18 2017-09-22 北京潘达互娱科技有限公司 Database-access rights application method and device

Family Cites Families (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2002041150A1 (en) * 2000-11-16 2002-05-23 Dlj Long Term Investment Corporation System and method for application-level security
US8027993B2 (en) * 2006-12-28 2011-09-27 Teradota Us, Inc. Techniques for establishing and enforcing row level database security
CN110727929B (en) * 2019-10-12 2021-07-30 北京明略软件系统有限公司 AOP-based line-level authority control method, device and client
CN111859442A (en) * 2020-01-21 2020-10-30 北京嘀嘀无限科技发展有限公司 Authority configuration method, authority configuration system and computer readable storage medium
CN111428257B (en) * 2020-03-30 2023-09-01 北京东方金信科技股份有限公司 System and method for opening database metadata through automatic approval
CN112085266A (en) * 2020-08-28 2020-12-15 云粒智慧科技有限公司 Government affair data processing method and device, electronic equipment and storage medium
CN113114674A (en) * 2021-04-12 2021-07-13 北京锐安科技有限公司 Service access method, device, equipment and storage medium
CN113934995A (en) * 2021-09-15 2022-01-14 南方电网深圳数字电网研究院有限公司 Rank authority setting method and device applied to data access
CN113987541A (en) * 2021-10-29 2022-01-28 四川省明厚天信息技术股份有限公司 Data access control method and device and electronic equipment

Patent Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107194272A (en) * 2017-04-18 2017-09-22 北京潘达互娱科技有限公司 Database-access rights application method and device

Also Published As

Publication number Publication date
CN115577381A (en) 2023-01-06

Similar Documents

Publication Publication Date Title
JP6840295B1 (en) Methods, devices, and computer program products that selectively grant permissions to group-based objects in group-based communication systems.
US10623406B2 (en) Access authentication for cloud-based shared content
US10193953B2 (en) Self describing configuration
US10915702B2 (en) Methods and systems for validating multiple methods of input using a unified rule set
US10592684B2 (en) Automatic operation detection on protected field
CN111767095A (en) Micro-service generation method and device, terminal equipment and storage medium
US20170116428A1 (en) Support sharing the same table for protected and non-protected data columns
US9769159B2 (en) Cookie optimization
CN111062028B (en) Authority management method and device, storage medium and electronic equipment
US11755698B2 (en) Systems, methods, and devices for automation and integration of credentialing and authentication in workflows associated with computing platforms
CN111680310A (en) Authority control method and device, electronic equipment and storage medium
CN108255967B (en) Method and device for calling storage process, storage medium and terminal
CN112464214A (en) Authority detection method and device, electronic equipment and readable storage medium
CN113190322A (en) Page acquisition method, related equipment and medium
CN115577381B (en) Line-level data access method and device and electronic equipment
CN111338607A (en) Method and device for selecting service data for testing and electronic equipment
US20150326577A1 (en) Accelerated application authentication and content delivery
US20220337569A1 (en) Systems, methods, and devices for automation and integration of credentialing and authentication in workflows associated with computing platforms
CN114386092A (en) Authority control method applied to semiconductor process equipment and semiconductor process equipment
CN115203671A (en) Account login method, device, equipment and storage medium
US11909729B2 (en) Auto-form fill based website authentication
CN111625465A (en) Program generation method, device and system and electronic equipment
CN111259424A (en) Product creation processing method, device, equipment and computer readable storage medium
US11630946B2 (en) Documentation augmentation using role-based user annotations
CN116886392A (en) Service processing method, device and network management system

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant