Invention Application
- Patent Title: Attribute Aware Relationship-Based Access Control on Row and Field Levels in a Relational Database
-
Application No.: US17326610Application Date: 2021-05-21
-
Publication No.: US20220374397A1Publication Date: 2022-11-24
- Inventor: Mang Fu Matthew Wong , Subhash Uppalapati , Jesse Wang , Sunghyun Song , Federico Recio , Jesse Collins
- Applicant: salesforce.com, inc.
- Applicant Address: US CA San Francisco
- Assignee: salesforce.com, inc.
- Current Assignee: salesforce.com, inc.
- Current Assignee Address: US CA San Francisco
- Main IPC: G06F16/21
- IPC: G06F16/21 ; G06F16/28 ; G06F16/2455

Abstract:
Systems and methods are described for implementing attribute aware, relationship-based access control by receiving a query to access a relational database from a user, determining if a rule of the relational database is applicable to the query, determining one or more relationships associated with the query based at least in part on the rule, and modifying the query by adding an extra join operation to the query based at least in part on the rule and the one or more relationships. Further, when a type of the rule is row level, a where clause filter is added to the modified query to enforce a condition of the rule, and when the type of the rule is field level, a case column is added to the modified query and a select clause is added to the modified query to wrap the query. The modified query is processed to produce a result.
Public/Granted literature
- US11755546B2 Attribute aware relationship-based access control on row and field levels in a relational database Public/Granted day:2023-09-12
Information query