Data table access method, device, computer equipment and storage medium
By performing permission verification and whitelist query in data table access, desensitized data tables are solved, and the problem of sensitive data leakage in traditional technology is improved.
Patent Information
- Application Number
- CN201910420383.0
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2019-05-20
- Publication Date
- 2024-11-05
- Estimated Expiration
- Not applicable · inactive patent
AI Technical Summary
Traditional data access permission control is difficult to effectively prevent sensitive data leakage, resulting in low data security.
By receiving the terminal's data table access request, access permission verification is performed. If the data table identifier is queried in the data table whitelist, and the desensitized data table corresponding to the identifier is obtained and returned to the terminal, thereby avoiding the leakage of sensitive data.
Improve data security, avoid leakage of sensitive data, and enhance security control of data access.
Smart Images

Figure CN110245505B_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the field of data processing technology, and in particular to a data table access method, device, computer equipment and storage medium. Background Art
[0002] With the development of computer technology and Internet technology, big data technology has emerged, and more and more data are transmitted or stored through the Internet. Many businesses can be handled directly through the Internet. When handling businesses, most of them need to fill in some sensitive data and store the sensitive data in the corresponding big database.
[0003] However, in order to ensure data security, traditional technologies use data access permission control to ensure data security in the database and avoid data leakage. However, personnel with access permission can access sensitive data, which can still easily lead to sensitive data leakage and low data security. Summary of the invention
[0004] Based on this, it is necessary to provide a data table access method, device, computer equipment and storage medium that can improve data security in response to the above technical problems.
[0005] A data table access method, the method comprising:
[0006] A data table access request sent by a receiving terminal;
[0007] Verify access rights for received data table access requests;
[0008] When the access permission verification is passed, the data table identifier in the data table access request is queried in the data table whitelist;
[0009] When the data table identifier is found in the data table whitelist, a desensitized data table corresponding to the found data table identifier is obtained;
[0010] The obtained anonymized data table is returned to the terminal.
[0011] A data table access device, the device comprising:
[0012] A request receiving module, used for receiving a data table access request sent by a terminal;
[0013] A request verification module is used to verify access rights of received data table access requests;
[0014] The identification query module is used to query the data table identification in the data table access request in the data table whitelist when the access permission verification is passed;
[0015] A data table acquisition module, used for acquiring a desensitized data table corresponding to the queried data table identifier when the data table identifier is queried in the data table whitelist;
[0016] The data table return module is used to return the obtained anonymized data table to the terminal.
[0017] A computer device comprises a memory and a processor, wherein the memory stores a computer program, and when the processor executes the computer program, the following steps are implemented:
[0018] A data table access request sent by a receiving terminal;
[0019] Verify access rights for received data table access requests;
[0020] When the access permission verification is passed, the data table identifier in the data table access request is queried in the data table whitelist;
[0021] When the data table identifier is found in the data table whitelist, a desensitized data table corresponding to the found data table identifier is obtained;
[0022] The obtained anonymized data table is returned to the terminal.
[0023] A computer-readable storage medium stores a computer program, which, when executed by a processor, implements the following steps:
[0024] A data table access request sent by a receiving terminal;
[0025] Verify access rights for received data table access requests;
[0026] When the access permission verification is passed, the data table identifier in the data table access request is queried in the data table whitelist;
[0027] When the data table identifier is found in the data table whitelist, a desensitized data table corresponding to the found data table identifier is obtained;
[0028] The obtained anonymized data table is returned to the terminal.
[0029] The above-mentioned data table access method, device, computer equipment and storage medium, when the access authority of the data table access request sent by the terminal is verified, the data table identifier in the data table access request is queried in the data whitelist, and when the data table identifier is queried, it indicates that the source data table corresponding to the queried data table identifier includes sensitive data. The desensitized data table corresponding to the queried data table identifier is obtained, and the obtained desensitized data table is returned to the terminal, thereby avoiding the leakage of sensitive data and improving the security of the data. BRIEF DESCRIPTION OF THE DRAWINGS
[0030] Figure 1 An application scenario diagram of a data table access method in an embodiment;
[0031] Figure 2 A schematic diagram of a flow chart of a data table access method in one embodiment;
[0032] Figure 3 A schematic flow chart of the steps of obtaining a desensitized data table in one embodiment;
[0033] Figure 4 A schematic diagram of a flow chart of steps for performing desensitization processing on a data table in one embodiment;
[0034] Figure 5 A schematic flow chart of the steps of performing a desensitization treatment according to a desensitization treatment method in one embodiment;
[0035] Figure 6 A schematic flow chart of the steps of exporting a data table in one embodiment;
[0036] Figure 7 is a structural block diagram of a data table access device in one embodiment;
[0037] Figure 8 FIG. 4 is a diagram showing the internal structure of a computer device in one embodiment. DETAILED DESCRIPTION
[0038] In order to make the purpose, technical solution and advantages of the present application more clearly understood, the present application is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.
[0039] The data table access method provided in this application can be applied to Figure 1 In the application environment shown, the terminal 102 communicates with the server 104 through a network. The terminal 102 may be, but is not limited to, various personal computers, laptops, smart phones, tablet computers, and portable wearable devices, and the server 104 may be implemented as an independent server or a server cluster consisting of multiple servers.
[0040] In one embodiment, Figure 2 As shown, a data table access method is provided, which is applied to Figure 1 The server in the example is used to illustrate the following steps:
[0041] S202: Receive a data table access request sent by a terminal.
[0042] Specifically, the terminal displays a data table access page, and when a click operation of a data access button in the data table access page is detected, the data table identifier entered in the data table access page is obtained, the obtained data table identifier is encapsulated, a data table access request is generated through encapsulation, and the data table access request is sent to the server. The server receives the data table access request sent by the terminal.
[0043] S204: Verify access rights for the received data table access request.
[0044] Specifically, after receiving a data table access request, the server parses the data table access request, extracts the user account and data table identifier in the data table access request, queries the access permission list corresponding to the access data table identifier, and verifies the user account according to the queried access permission list.
[0045] In one embodiment, the user account is queried in the access permission list. When the user account is found, it is determined that the user account has access permission to the data table corresponding to the data table identifier, that is, the access permission verification is passed; when the user account is not found, it is determined that the user account does not have access permission to the data table corresponding to the data table identifier, that is, the access permission verification is failed.
[0046] S206: When the access authority verification is passed, the data table identifier in the data table access request is searched in the data table whitelist.
[0047] Specifically, when it is verified that the user account has access rights to the data table corresponding to the data table identifier, the server obtains a data table whitelist. The data table whitelist records the data table identifiers corresponding to the data tables that include sensitive data segments. The server extracts the data table identifier in the data table access request and searches the data table whitelist for the extracted data table identifier. When the extracted data table identifier is found in the data table whitelist, it indicates that the source data table corresponding to the extracted data table identifier includes sensitive data; when the extracted data table identifier is not found in the data table whitelist, it indicates that the source data table corresponding to the extracted data table identifier does not include sensitive data.
[0048] In one embodiment, the steps after S206 specifically include: when the data table identifier is not found in the data table whitelist, querying the source data table corresponding to the data table identifier, and returning the queried source data table to the terminal; when the data table identifier is found in the data table whitelist, executing S208.
[0049] Specifically, when the data table identifier is not found in the data table whitelist, it means that the data table corresponding to the data table identifier does not need to be desensitized, and the source data table corresponding to the data table identifier is queried from the database, and the queried source data table is sent to the terminal. The source data table is a data table that has not been desensitized.
[0050] S208, when the data table identifier is found in the data table whitelist, a desensitized data table corresponding to the found data table identifier is obtained.
[0051] Specifically, the desensitized data table is a data table obtained by desensitizing the source data table. When the server queries the extracted data table identifier in the data table whitelist, it determines the desensitized data table corresponding to the queried data table identifier from the desensitized data table, and obtains the determined desensitized data table. Different desensitized data tables correspond to different data table identifiers. The desensitized data table has a unique data table identifier.
[0052] S210, returning the obtained desensitized data table to the terminal.
[0053] Specifically, the server obtains the terminal identifier in the data table access request, and returns the obtained desensitized data table to the terminal according to the terminal identifier.
[0054] In one embodiment, the server obtains the user account in the data table access request, determines the terminal identifier corresponding to the terminal logged in by the user account, and sends the desensitized data table to the terminal according to the terminal identifier.
[0055] In this embodiment, when the access authority of the data table access request sent by the terminal is verified, the data table identifier in the data table access request is queried in the data whitelist. When the data table identifier is queried, it means that the source data table corresponding to the queried data table identifier includes sensitive data. The desensitized data table corresponding to the queried data table identifier is obtained, and the obtained desensitized data table is returned to the terminal, thereby avoiding the leakage of sensitive data and improving the security of the data.
[0056] like Figure 3 As shown, in one embodiment, before S202, the step of obtaining a desensitized data table is specifically included, and the step specifically includes the following contents:
[0057] S302, regularly traverse the data tables in the database.
[0058] Specifically, a plurality of databases are provided in the server, and a plurality of data tables are stored in each database. The server periodically traverses the data tables in each database. The server starts timing after obtaining the last traversal, and when the timed length is equal to the preset time length, the traversal of the database in each database is restarted.
[0059] S304: Determine whether there is a sensitive data segment in the traversed data table according to the preset sensitive keyword.
[0060] Specifically, a preset sensitive keyword is set in the server, and the preset sensitive keyword includes at least one of a name, a telephone number, and an address. The server determines whether the data segment identifier in the traversed data table includes the preset sensitive keyword. When it is determined that the data segment identifier in the traversed data table includes the preset sensitive keyword, it means that the traversed data table includes a sensitive data segment; when it is determined that the data segment identifier in the traversed data table does not include the preset sensitive keyword, it means that the traversed data table does not include a sensitive data segment.
[0061] S306, when it is determined that there is a sensitive data segment in the traversed data table, desensitizing the data corresponding to the sensitive data segment in the traversed data table to obtain a desensitized data table corresponding to the traversed data table.
[0062] Specifically, when it is determined that there is a sensitive data segment in the traversed data table, the sensitive data corresponding to the sensitive data segment in the traversed data table is determined, the determined sensitive data is desensitized, and the data table after the pseudonym processing is used as the desensitized data table corresponding to the traversed data table.
[0063] In this embodiment, the data tables in the database are traversed regularly, and it is determined whether there are sensitive data segments in the traversed data tables based on preset sensitive keywords. When it is determined that there are sensitive data segments in the traversed data tables, the traversed data tables are desensitized to obtain desensitized data tables, ensuring that when the data tables are accessed, the desensitized data tables are returned, thereby improving the security of sensitive data.
[0064] like Figure 4 As shown, in one embodiment, S306 specifically includes the step of desensitizing the data table, which specifically includes the following contents:
[0065] S402, when it is determined that there is a sensitive data segment in the traversed data table, a desensitization confirmation notification is generated according to the data table identifier corresponding to the traversed data table.
[0066] Specifically, when it is determined that there are sensitive data segments in the traversed data table, the data table identifier corresponding to the traversed data table is obtained, the obtained data table identifier is encapsulated, and a desensitization confirmation notification is generated through encapsulation. The desensitization confirmation notification is used to notify the table administrator whether to determine whether to perform desensitization processing on the data table.
[0067] S404, sending a desensitization confirmation notification to the terminal logged in with the table administrator account.
[0068] Specifically, the server queries the table administrator account corresponding to the data table identifier, obtains the terminal address corresponding to the terminal logged in with the table administrator account, and sends the desensitization confirmation notification to the terminal corresponding to the terminal address according to the obtained terminal address.
[0069] S406, receiving a desensitization confirmation instruction returned by the terminal logged in with the table administrator account according to the desensitization confirmation notification.
[0070] Specifically, after receiving the desensitization confirmation notification, the terminal logged in with the table administrator account parses the desensitization confirmation notification, obtains the data table identifier through parsing, and displays the obtained data table identifier on the desensitization confirmation page. When a click operation of the Confirm Desensitization button in the desensitization confirmation page is detected, the displayed data table identifier is obtained, and a confirmation desensitization instruction is generated according to the obtained data table identifier, and the generated confirmation desensitization instruction is sent to the server. The server receives the confirmation desensitization instruction returned by the terminal according to the desensitization confirmation notification.
[0071] S408, performing desensitization processing on the traversed data table according to the confirmed desensitization instruction, and obtaining a desensitized data table corresponding to the traversed data table.
[0072] Specifically, the server extracts and confirms the data table identifier in the desensitizing instruction, verifies whether the extracted data table identifier is consistent with the data table identifier corresponding to the traversed data table, and when the verification is consistent, desensitizes the traversed data table to obtain a desensitized data table corresponding to the traversed data table.
[0073] In this embodiment, when there are sensitive data segments in the traversed data table, a desensitization confirmation notification is generated according to the data table identifier corresponding to the traversed data table, and the desensitization confirmation notification is sent to the terminal logged in with the table administrator account to notify the table administrator that the data table needs to be desensitized. After receiving the confirmation desensitization instruction returned by the terminal logged in with the table administrator account according to the desensitization confirmation notification, the traversed data table is desensitized to avoid desensitizing the data table that does not need to be desensitized, thereby improving the desensitization accuracy of the data table.
[0074] like Figure 5 In one embodiment, S408 specifically includes the step of performing desensitization processing according to the desensitization processing method, and the step specifically includes the following contents:
[0075] S502, extract and confirm the data table identifier and data segment identifier in the desensitization instruction.
[0076] Specifically, the server parses the confirmation desensitization instruction and extracts the data table identifier and the data segment identifier from the confirmation desensitization instruction through parsing. The data segment identifier is an identifier for identifying each data segment in the data table. For example, the data segment identifier may include at least one of a name, a telephone number, and a home address.
[0077] S504: Identify the data type corresponding to the data segment identifier in the data table corresponding to the data table identifier.
[0078] Specifically, after the server extracts the data table identifier and the data segment identifier from the confirmation desensitization instruction, it queries the data table corresponding to the extracted data table identifier from the database, queries the data segment corresponding to the data segment identifier in the queried data table, obtains the data type identifier of the data segment, and identifies the data type corresponding to the data segment identifier according to the data type identifier. Data types include associated data and non-associated data, and associated data is data used by a data table to associate with other data tables.
[0079] S506: Determine a desensitization processing method corresponding to the identified data type.
[0080] Specifically, the server is provided with a desensitization processing method corresponding to each data type, and the desensitization processing method includes at least one of sensitive character replacement, sensitive data encryption, and sensitive data deletion. When the server identifies a data type, it queries the desensitization processing method corresponding to the identified data type, and uses the queried desensitization processing method as the desensitization processing method corresponding to the identified data type.
[0081] S508, performing desensitization processing on the data corresponding to the data segment identifier according to the determined desensitization processing method, and obtaining a desensitized data table corresponding to the traversed data table.
[0082] Specifically, when the desensitizing processing method is sensitive data encryption, the server obtains a preset key, and encrypts the sensitive data in the data segment corresponding to the data segment identifier in the data table according to the preset key, and uses the encrypted data table as the desensitized data table.
[0083] In one embodiment, when the desensitization processing method is sensitive character replacement, the server determines the sensitive characters included in the data segment in the data table, and replaces the sensitive characters with the specified symbols. For example, the mobile phone number is desensitized to obtain the desensitized data of 189****6789.
[0084] In one embodiment, the server determines the sensitive data corresponding to the data segment identifier in the data table corresponding to the data table identifier, deletes the determined sensitive data, and obtains a desensitized data table after desensitization processing.
[0085] In this embodiment, by identifying the data type of sensitive data, querying the desensitizing processing method corresponding to the identified data type, and desensitizing the data table according to the queried desensitizing processing method, desensitizing processing is performed according to different desensitizing processing methods according to different data types, thereby further improving the security of the desensitized data table.
[0086] like Figure 6 As shown, in one embodiment, after S210, the step of exporting the data table is specifically included, and the step specifically includes the following contents:
[0087] S602: Receive a table export request sent by a terminal.
[0088] Specifically, when the terminal receives the desensitized data table returned by the server, it displays the desensitized data table on the data table access page, and when a click operation of the data table export button on the data table access page is detected, the data table identifier corresponding to the desensitized data table is obtained, a table export request is generated according to the obtained data table identifier, and the table export request is sent to the server. The server receives the table export request sent by the terminal.
[0089] S604: Obtain the desensitized data in the desensitized data table corresponding to the data table identifier in the table export request.
[0090] Specifically, after receiving the table export request, the server parses the table export request, extracts the data table identifier in the table export request through parsing, queries the desensitized data table corresponding to the extracted data table identifier, and obtains the data in the desensitized data table as desensitized data.
[0091] S606, adding the obtained desensitized data to a temporary data table to generate an export data table.
[0092] Specifically, the server reads the format information in the desensitized data table, creates a temporary data table according to the format information, adds the acquired desensitized data to the temporary data table, and uses the temporary data table to which the desensitized data is added as the export data table.
[0093] S608, sending the exported data table to the terminal.
[0094] Specifically, the server extracts the terminal address in the table export request, and sends the exported data table to the terminal corresponding to the terminal address.
[0095] In this embodiment, after receiving a table export request, the data table identifier in the table export request is extracted, the desensitized data table corresponding to the data table identifier is queried, an export data table is generated based on the desensitized data in the desensitized data table, and the export data table is sent to the terminal to prevent the data table that has not been desensitized from being exported, thereby reducing the risk of data leakage and improving the security of the data table.
[0096] It should be understood that although Figure 2-6 The steps in the flowchart are shown in sequence as indicated by the arrows, but these steps are not necessarily executed in the order indicated by the arrows. Unless otherwise specified in this document, there is no strict order restriction for the execution of these steps, and these steps can be executed in other orders. Moreover, Figure 2-6At least part of the steps may include multiple sub-steps or multiple stages. These sub-steps or stages are not necessarily executed at the same time, but can be executed at different times. The execution order of these sub-steps or stages is not necessarily sequential, but can be executed in turn or alternately with other steps or at least part of the sub-steps or stages of other steps.
[0097] In one embodiment, Figure 7 As shown, a data table access device 700 is provided, comprising: a request receiving module 702, a request verification module 704, an identification query module 706, a data table acquisition module 708 and a data table return module 710, wherein:
[0098] The request receiving module 702 is used to receive a data table access request sent by a terminal.
[0099] The request verification module 704 is used to verify the access permission of the received data table access request.
[0100] The identification query module 706 is used to query the data table identification in the data table access request in the data table whitelist when the access authority verification is passed.
[0101] The data table acquisition module 708 is used to acquire the desensitized data table corresponding to the queried data table identifier when the data table identifier is queried in the data table whitelist.
[0102] The data table returning module 710 is used to return the obtained anonymized data table to the terminal.
[0103] In one embodiment, the data table access device 700 further includes: a data desensitization module.
[0104] The data desensitization module is used to periodically traverse the data tables in the database; determine whether there is a sensitive data segment in the traversed data table based on preset sensitive keywords; when it is determined that there is a sensitive data segment in the traversed data table, desensitize the data corresponding to the sensitive data segment in the traversed data table to obtain a desensitized data table corresponding to the traversed data table.
[0105] In one embodiment, the data desensitizing module is also used to generate a desensitizing confirmation notification based on the data table identifier corresponding to the traversed data table when it is determined that there is a sensitive data segment in the traversed data table; send the desensitizing confirmation notification to the terminal logged in with the table administrator account; receive a confirmation desensitizing instruction returned by the terminal logged in with the table administrator account based on the desensitizing confirmation notification; desensitize the traversed data table according to the confirmation desensitizing instruction, and obtain a desensitized data table corresponding to the traversed data table.
[0106] In one embodiment, the data desensitization module is also used to extract the data table identifier and the data segment identifier in the confirmation desensitization instruction; in the data table corresponding to the data table identifier, identify the data type corresponding to the data segment identifier; determine the desensitization processing method corresponding to the identified data type; desensitize the data corresponding to the data segment identifier according to the determined desensitization processing method, and obtain a desensitized data table corresponding to the traversed data table.
[0107] In one embodiment, the data table acquisition module 708 is also used to query the source data table corresponding to the data table identifier when the data table identifier is not found in the data table whitelist, and return the queried source data table to the terminal; when the data table identifier is found in the data table whitelist, obtain the desensitized data table corresponding to the queried access data table identifier.
[0108] In one embodiment, the data table access device 700 further includes: a table export module.
[0109] The table export module is used to receive a table export request sent by a terminal; obtain the desensitized data in the desensitized data table corresponding to the data table identifier in the table export request; add the obtained desensitized data to a temporary data table to generate an export data table; and send the export data table to the terminal.
[0110] In this embodiment, when the access authority of the data table access request sent by the terminal is verified, the data table identifier in the data table access request is queried in the data whitelist. When the data table identifier is queried, it means that the source data table corresponding to the queried data table identifier includes sensitive data. The desensitized data table corresponding to the queried data table identifier is obtained, and the obtained desensitized data table is returned to the terminal, thereby avoiding the leakage of sensitive data and improving the security of the data.
[0111] The specific definition of the data table access device can be found in the definition of the data table access method above, which will not be repeated here. Each module in the above-mentioned data table access device can be implemented in whole or in part by software, hardware and a combination thereof. The above-mentioned modules can be embedded in or independent of the processor in the computer device in the form of hardware, or can be stored in the memory in the computer device in the form of software, so that the processor can call and execute the operations corresponding to the above modules.
[0112] In one embodiment, a computer device is provided. The computer device may be a server, and its internal structure diagram may be as follows: Figure 8As shown. The computer device includes a processor, a memory, a network interface and a database connected through a system bus. Among them, the processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program and a database. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The database of the computer device is used to store data tables. The network interface of the computer device is used to communicate with an external terminal through a network connection. When the computer program is executed by the processor, a data table access method is implemented.
[0113] Those skilled in the art will understand that Figure 8 The structure shown in the figure is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than those shown in the figure, or combine certain components, or have a different arrangement of components.
[0114] In one embodiment, a computer device is provided, including a memory and a processor, the memory storing a computer program, and the processor implementing the following steps when executing the computer program: receiving a data table access request sent by a terminal; performing access permission verification on the received data table access request; when the access permission verification passes, querying a data table identifier in the data table access request in a data table whitelist; when the data table identifier is queried in the data table whitelist, obtaining a desensitized data table corresponding to the queried data table identifier; and returning the obtained desensitized data table to the terminal.
[0115] In one embodiment, before receiving a data table access request sent by a terminal, the processor also implements the following steps when executing a computer program: regularly traversing the data tables in the database; determining whether there is a sensitive data segment in the traversed data table based on preset sensitive keywords; when it is determined that there is a sensitive data segment in the traversed data table, desensitizing the data corresponding to the sensitive data segment in the traversed data table to obtain a desensitized data table corresponding to the traversed data table.
[0116] In one embodiment, when it is determined that there are sensitive data segments in the traversed data table, the data corresponding to the sensitive data segments in the traversed data table are desensitized, and a desensitized data table corresponding to the traversed data table is obtained, including: when it is determined that there are sensitive data segments in the traversed data table, a desensitization confirmation notification is generated according to the data table identifier corresponding to the traversed data table; the desensitization confirmation notification is sent to a terminal logged in with a table administrator account; a confirmation desensitization instruction returned by the terminal logged in with the table administrator account according to the desensitization confirmation notification; the traversed data table is desensitized according to the confirmation desensitization instruction, and a desensitized data table corresponding to the traversed data table is obtained.
[0117] In one embodiment, the traversed data table is desensitized according to the confirmation desensitization instruction to obtain the desensitized data table corresponding to the traversed data table, including: extracting the data table identifier and the data segment identifier in the confirmation desensitization instruction; identifying the data type corresponding to the data segment identifier in the data table corresponding to the data table identifier; determining the desensitization processing method corresponding to the identified data type; desensitizing the data corresponding to the data segment identifier according to the determined desensitization processing method to obtain the desensitized data table corresponding to the traversed data table.
[0118] In one embodiment, when the access permission verification is passed, after the data table identifier in the data table access request is queried in the data table whitelist, the processor also implements the following steps when executing the computer program: when the data table identifier is not queried in the data table whitelist, query the source data table corresponding to the data table identifier, and return the queried source data table to the terminal; when the data table identifier is queried in the data table whitelist, execute the step of obtaining a desensitized data table corresponding to the queried access data table identifier.
[0119] In one embodiment, after returning the obtained desensitized data table to the terminal, the processor also implements the following steps when executing the computer program: receiving a table export request sent by the terminal; obtaining the desensitized data in the desensitized data table corresponding to the data table identifier in the table export request; adding the obtained desensitized data to a temporary data table to generate an exported data table; and sending the exported data table to the terminal.
[0120] In this embodiment, when the access authority of the data table access request sent by the terminal is verified, the data table identifier in the data table access request is queried in the data whitelist. When the data table identifier is queried, it means that the source data table corresponding to the queried data table identifier includes sensitive data. The desensitized data table corresponding to the queried data table identifier is obtained, and the obtained desensitized data table is returned to the terminal, thereby avoiding the leakage of sensitive data and improving the security of the data.
[0121] In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored. When the computer program is executed by a processor, the following steps are implemented: receiving a data table access request sent by a terminal; performing access permission verification on the received data table access request; when the access permission verification passes, querying a data table identifier in the data table access request in a data table whitelist; when the data table identifier is queried in the data table whitelist, obtaining a desensitized data table corresponding to the queried data table identifier; and returning the obtained desensitized data table to the terminal.
[0122] In one embodiment, before receiving a data table access request sent by a terminal, the computer program also implements the following steps when executed by a processor: regularly traversing the data tables in a database; determining whether there is a sensitive data segment in the traversed data table based on preset sensitive keywords; when it is determined that there is a sensitive data segment in the traversed data table, desensitizing the data corresponding to the sensitive data segment in the traversed data table to obtain a desensitized data table corresponding to the traversed data table.
[0123] In one embodiment, when it is determined that there are sensitive data segments in the traversed data table, the data corresponding to the sensitive data segments in the traversed data table are desensitized, and a desensitized data table corresponding to the traversed data table is obtained, including: when it is determined that there are sensitive data segments in the traversed data table, a desensitization confirmation notification is generated according to the data table identifier corresponding to the traversed data table; the desensitization confirmation notification is sent to a terminal logged in with a table administrator account; a confirmation desensitization instruction returned by the terminal logged in with the table administrator account according to the desensitization confirmation notification; the traversed data table is desensitized according to the confirmation desensitization instruction, and a desensitized data table corresponding to the traversed data table is obtained.
[0124] In one embodiment, the traversed data table is desensitized according to the confirmation desensitization instruction to obtain the desensitized data table corresponding to the traversed data table, including: extracting the data table identifier and the data segment identifier in the confirmation desensitization instruction; identifying the data type corresponding to the data segment identifier in the data table corresponding to the data table identifier; determining the desensitization processing method corresponding to the identified data type; desensitizing the data corresponding to the data segment identifier according to the determined desensitization processing method to obtain the desensitized data table corresponding to the traversed data table.
[0125] In one embodiment, when the access permission verification is passed, after the data table identifier in the data table access request is queried in the data table whitelist, the computer program also implements the following steps when executed by the processor: when the data table identifier is not queried in the data table whitelist, query the source data table corresponding to the data table identifier, and return the queried source data table to the terminal; when the data table identifier is queried in the data table whitelist, execute the step of obtaining the desensitized data table corresponding to the queried access data table identifier.
[0126] In one embodiment, after the obtained desensitized data table is returned to the terminal, the computer program also implements the following steps when executed by the processor: receiving a table export request sent by the terminal; obtaining the desensitized data in the desensitized data table corresponding to the data table identifier in the table export request; adding the obtained desensitized data to a temporary data table to generate an exported data table; and sending the exported data table to the terminal.
[0127] In this embodiment, when the access authority of the data table access request sent by the terminal is verified, the data table identifier in the data table access request is queried in the data whitelist. When the data table identifier is queried, it means that the source data table corresponding to the queried data table identifier includes sensitive data. The desensitized data table corresponding to the queried data table identifier is obtained, and the obtained desensitized data table is returned to the terminal, thereby avoiding the leakage of sensitive data and improving the security of the data.
[0128] Those skilled in the art can understand that all or part of the processes in the above-mentioned embodiment methods can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to memory, storage, database or other media used in the embodiments provided in the present application can include non-volatile and / or volatile memory. Non-volatile memory can include read-only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM) or flash memory. Volatile memory can include random access memory (RAM) or external cache memory. As an illustration and not limitation, RAM is available in many forms, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double data rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).
[0129] The technical features of the above embodiments may be combined arbitrarily. To make the description concise, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.
[0130] The above-mentioned embodiments only express several implementation methods of the present application, and the descriptions thereof are relatively specific and detailed, but they cannot be understood as limiting the scope of the invention patent. It should be pointed out that, for a person of ordinary skill in the art, several variations and improvements can be made without departing from the concept of the present application, and these all belong to the protection scope of the present application. Therefore, the protection scope of the patent of the present application shall be subject to the attached claims.
Claims
1. A data table access method, the method comprising: Regularly traverse the data tables in the database; Determine whether the data segment identifier in the traversed data table includes a preset sensitive keyword; The data segment identifier is an identifier of each data segment in the data table; When it is determined that the data segment identifier in the traversed data table includes a preset sensitive keyword, it is determined that the traversed data table includes a sensitive data segment; Generate a desensitization confirmation notification according to the data table identifier corresponding to the traversed data table; Send the desensitization confirmation notification to the terminal logged in with the table administrator account; Receiving the desensitization confirmation instruction returned by the terminal logged in with the table administrator account according to the desensitization confirmation notification; Extracting the data table identifier and the data segment identifier in the confirmation desensitization instruction; Querying a data table corresponding to the extracted data table identifier from a database, querying a data segment corresponding to the data segment identifier from the data table, obtaining a data type identifier for the data segment, obtaining a data type corresponding to the data segment identifier according to the data type identifier, and determining a desensitization processing method corresponding to the data type corresponding to the data segment identifier; Data types include associated data and non-associated data. Associated data refers to data used by a data table to associate with other data tables. Desensitizing the data corresponding to the data segment identifier according to the determined desensitizing processing method to obtain a desensitized data table corresponding to the traversed data table; A data table access request sent by a receiving terminal; Verify access rights for received data table access requests; When the access permission verification is passed, the data table identifier in the data table access request is queried in the data table whitelist; The data table whitelist records the data table identifiers corresponding to the data tables including the sensitive data segments; Passing the access permission verification means that the user account in the data table access request has access permission to the data table corresponding to the data table identifier in the data table access request; When the data table identifier is found in the data table whitelist, a desensitized data table corresponding to the found data table identifier is obtained; The obtained anonymized data table is returned to the terminal.
2. The method according to claim 1, characterized in that The data segment identifier includes at least one of a name, a telephone number, and a home address.
3. The method according to claim 1, characterized in that After the access permission verification is passed, after searching the data table whitelist for the data table identifier in the data table access request, the method further includes: When the data table identifier is not found in the data table whitelist, a source data table corresponding to the data table identifier is queried, and the queried source data table is returned to the terminal.
4. The method according to claim 1, characterized in that After returning the obtained desensitized data table to the terminal, the method further includes: receiving a table export request sent by the terminal; Obtain the desensitized data in the desensitized data table corresponding to the data table identifier in the table export request; Add the obtained desensitized data to the temporary data table and generate an export data table; The exported data table is sent to the terminal.
5. A data table access device, characterized in that: The device comprises: The data desensitization module is used to periodically traverse the data table in the database; determine whether the data segment identifier in the traversed data table includes a preset sensitive keyword; the data segment identifier is an identifier for identifying each data segment in the data table; when it is determined that the data segment identifier in the traversed data table includes the preset sensitive keyword, determine that the traversed data table includes a sensitive data segment; generate a desensitization confirmation notice according to the data table identifier corresponding to the traversed data table; send the desensitization confirmation notice to a terminal logged in with a table administrator account; receive the confirmation desensitization instruction returned by the terminal logged in with the table administrator account according to the desensitization confirmation notice; extract the data in the confirmation desensitization instruction Table identifier and data segment identifier; query the data table corresponding to the extracted data table identifier from the database, query the data segment corresponding to the data segment identifier from the data table, obtain the data type identifier of the data segment, obtain the data type corresponding to the data segment identifier according to the data type identifier, and determine the desensitization processing method corresponding to the data type corresponding to the data segment identifier; data types include associated data and non-associated data, and associated data is data used by the data table to associate with other data tables; desensitize the data corresponding to the data segment identifier according to the determined desensitization processing method to obtain the desensitized data table corresponding to the traversed data table; A request receiving module, used for receiving a data table access request sent by a terminal; A request verification module is used to verify access rights of received data table access requests; The identification query module is used to query the data table identification in the data table access request in the data table whitelist when the access permission is verified; the data table whitelist records the data table identification corresponding to the data table including the sensitive data segment; the access permission verification is passed means that the user account in the data table access request has access permission to the data table corresponding to the data table identification in the data table access request; A data table acquisition module, used for acquiring a desensitized data table corresponding to the queried data table identifier when the data table identifier is queried in the data table whitelist; The data table return module is used to return the obtained anonymized data table to the terminal.
6. The device according to claim 5, characterized in that The data segment identifier includes at least one of a name, a telephone number, and a home address.
7. The device according to claim 5, characterized in that The data table acquisition module is further used for: when the data table identifier is not found in the data table whitelist, querying the source data table corresponding to the data table identifier, and returning the found source data table to the terminal.
8. The device according to claim 5, characterized in that The device also includes: A table export module, used for receiving a table export request sent by the terminal; Obtain the desensitized data in the desensitized data table corresponding to the data table identifier in the table export request; Add the obtained desensitized data to the temporary data table and generate an export data table; The exported data table is sent to the terminal.
9. A computer device comprising a memory and a processor, wherein the memory stores a computer program, wherein: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 4 are implemented.
10. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 4 are implemented.
