Reach Object Instance-Level Row Security
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing database systems lack effective row-level security mechanisms that allow for instance-level access control without requiring changes to the presentation tier or direct interaction with the data tier, leading to potential unauthorized access to sensitive data.
Innovation Solution
Implementing a link data structure in the data tier that associates users with specific objects, using a reach object to secure individual data items at the instance level, allowing authorized access without modifying the user interface or presentation tier.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If row-level security is implemented using traditional database access control, then data security is improved, but system complexity and difficulty of implementation increase
Solution Approach 1:
The patent introduces a reach object as an intermediary component between the presentation tier and data tier. This reach object automatically manages row-level security by intercepting data access requests, determining user permissions, and filtering results before returning data to users. This mediator approach eliminates the need for complex security logic in the presentation tier while maintaining strong security controls at the data access layer.
Solution Approach 2:
The patent segments security functionality into a separate reach object component that can be independently managed and configured. By dividing the security mechanism into discrete, reusable objects that can be attached to specific data access operations, the system achieves fine-grained security control without requiring comprehensive restructuring of the entire application architecture.
2Reliability
If instance-level security control is implemented, then unauthorized access to sensitive data is prevented, but the complexity of access control mechanisms increases
Solution Approach 1:
The reach object implements self-service security by automatically determining user permissions and filtering data based on pre-configured security rules. When a user requests data through the reach object, the mechanism automatically evaluates the user's authorization level, applies appropriate filters, and returns only permitted data without requiring manual security checks or complex configuration at each access point.
Solution Approach 2:
Security rules and user permissions are pre-configured in the reach object before runtime data access occurs. This preliminary setup of security parameters allows the system to automatically enforce instance-level security controls during data operations without requiring complex real-time decision-making or manual intervention, thereby reducing operational complexity while maintaining strong security.
3Ease of operation
If row-level security is implemented without modifying the presentation tier, then ease of operation is improved, but the ability to implement fine-grained security decreases
Solution Approach 1:
The patent adds a new dimensional layer (the reach object layer) between the presentation tier and data tier, enabling fine-grained security control without modifying existing presentation layer code. This additional dimension allows security logic to be injected at the data access boundary while keeping the presentation tier simple and unchanged, effectively resolving the contradiction between operational simplicity and security flexibility.
Data Source
AI summary
Methods, systems, and apparatus, including computer programs encoded on computer storage media, for a row level security. One of the methods includes receiving, by a computer device executing at least part of a functional logic tier of an application, a request from a user for one or more objects present in the functional logic tier. The method includes determining that a type of the requested objects is associated with an object representative of instance level security. The method includes in response to determining that the type is associated with the object, determining access is authorized to at least some of the objects, determining access comprising accessing, by a computer device executing at least part of a data tier of the application, a link data structure that links the user with at least some of the objects. The method also includes providing the at least some of the objects to the user.


