Invention Grant
- Patent Title: Resource-efficient row-level security in database systems
-
Application No.: US17747115Application Date: 2022-05-18
-
Publication No.: US12013961B2Publication Date: 2024-06-18
- Inventor: Sen Zhang , De-Li Xu , Zhi-Peng Dong , Jixiang Xv , Sheng Cheng , Ruiming Dang
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Fish & Richardson P.C.
- Main IPC: G06F17/30
- IPC: G06F17/30 ; G06F12/14 ; G06F16/21 ; G06F16/28 ; G06F21/62

Abstract:
Methods, systems, and computer-readable storage media for receiving a query request including authorization data and a query, the authorization data indicating a privilege level index, determining a set of row ranges based on the privilege level index and a row range table, the set of row ranges including one or more row ranges having a privilege level associated therewith in the row range table, providing an initial results set including one or more records of a data table that are determined to be responsive, determining a final results set including at least one record of the initial results set, the at least one record being included in the final results set in response to determining that the at least one record is included in a row range of the set of row ranges, and outputting the final results set as at least a portion of a query result.
Public/Granted literature
- US20230376623A1 RESOURCE-EFFICIENT ROW-LEVEL SECURITY IN DATABASE SYSTEMS Public/Granted day:2023-11-23
Information query