Custom Share Row Cause Linking in On-Demand Service
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional database systems lack flexibility in sharing records, allowing them to be used only by the owner and the administrator of the organization associated with the owner, limiting access and control among users.
Innovation Solution
The implementation of mechanisms and methods to link a custom share row cause to a sharing record associated with a custom object in an on-demand service, enabling users to share custom object records and specify the custom row cause, which allows identification of the source and purpose of the sharing record, as well as controlling access and updates.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If conventional database systems allow only the owner and administrator to access records, then data security and ownership control are maintained, but user flexibility and sharing capability are limited
Solution Approach 1:
The patent segments access control by introducing sharing records that separate owner privileges from shared user privileges. The sharing record structure divides access rights into distinct components: owner identification, shared user identification, and cause identification, allowing granular control over who can access and modify records without requiring complete reauthorization.
Solution Approach 2:
The patent introduces sharing records as an intermediary mechanism between the owner and shared users. These records act as a mediator that establishes authorized access relationships, allowing users to share records without becoming administrators while maintaining security through the cause field that tracks the origin of sharing permissions.
2Ease of operation
If sharing records can be freely created and modified, then user flexibility is improved, but data integrity and security may be compromised
Solution Approach 1:
The patent implements feedback through the cause field in sharing records, which tracks the origin and reason for each sharing operation. This creates an audit trail that provides feedback on sharing operations, allowing the system to monitor and control modifications while maintaining flexibility. The cause field serves as a feedback mechanism that records who initiated sharing and why, enabling integrity verification.
Solution Approach 2:
The patent applies preliminary action by establishing sharing records with predefined cause values before modifications occur. The system pre-defines valid cause options (such as 'shared by owner', 'shared by administrator') that constrain future operations, ensuring data integrity is maintained through predetermined authorized actions rather than allowing arbitrary modifications.
3Ease of operation
If administrators have full control over sharing records, then security is maintained, but user autonomy and ease of sharing are reduced
Solution Approach 1:
The patent enables self-service by allowing record owners to create sharing records independently without administrator intervention. Owners can specify shared users and provide cause information directly, empowering them to manage their own data sharing needs. This self-service capability reduces the permission hierarchy complexity by eliminating the need for administrator approval in standard sharing scenarios.
Solution Approach 2:
The patent applies local quality by granting different levels of control to different users based on their role and the specific record context. Owners have full control over their records, administrators have system-wide control, and shared users have controlled access based on the cause field. This localized quality of control allows ease of operation for owners while maintaining security through the permission hierarchy.
4Stability of the object's composition
If sharing records are allowed to persist through ownership changes, then access continuity is improved, but complexity of managing shared access increases
Solution Approach 1:
The patent applies preliminary action by designing sharing records with inherent persistence characteristics that automatically maintain access continuity through ownership changes. The sharing record structure is pre-configured to recognize and maintain valid shares even when the owner changes, eliminating the need for manual reconfiguration and reducing management complexity despite the increased stability requirement.
Data Source
AI summary
In accordance with embodiments, there are provided mechanisms and methods for linking a custom share row cause to a sharing record associated with a custom object in an on-demand service. These mechanisms and methods for linking custom share row causes to sharing records associated with an instance of a custom object in an on-demand service can enable a user or code executed by a user to share a custom object record with one or more users and to specify a custom row cause in that sharing record. The ability of embodiments to link custom share row causes to sharing records may allow users of such on-demand services to utilize custom row causes to determine why a sharing record was added and to identify the source of a sharing record.