Lightweight Worksheet References for Secure Non-Owner Access
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing data processing systems face challenges in securely allowing non-owners to interact with and modify worksheets generated by others without risking destructive edits, as current permissions are binary, either preventing all changes or allowing full access.
Innovation Solution
Implementing lightweight references that present worksheets in a view mode, preventing destructive edits while allowing additive edits, by generating dynamic referencing worksheets based on requests from non-owners, which inherit data sets and formula results but lack direct access to the original database, thus restricting permissions to prevent unauthorized modifications.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If binary permissions are used to control worksheet access, then security is simplified, but flexibility of access control deteriorates
Solution Approach 1:
The permission system is segmented into two distinct modes: view mode for non-owners and edit mode for owners. This segmentation allows different permission levels to be applied to different user groups, providing flexibility without requiring a complex multi-level permission system. The segmentation resolves the contradiction by enabling adaptable access control while maintaining simple binary permission structures.
Solution Approach 2:
The system dynamically adjusts the worksheet state based on user identity. When a non-owner requests a worksheet, it is dynamically transformed into view mode with restricted permissions. When the owner accesses it, the worksheet remains in edit mode. This dynamic behavior provides flexible access control while keeping the underlying permission mechanism simple.
2Ease of operation
If non-owners are allowed to edit worksheets, then usability is improved, but risk of destructive edits increases
Solution Approach 1:
The view mode acts as an intermediary state between complete read-only access and full edit access. It provides non-owners with additive editing capabilities while maintaining protective constraints that prevent destructive operations. This intermediary mode resolves the contradiction by enabling usability improvements without compromising reliability.
Solution Approach 2:
The system changes the permission parameters of the worksheet based on user identity. For non-owners, the worksheet is presented with modified parameters that enable additive edits but disable destructive operations. This parameter change approach allows the system to maintain reliability while improving ease of operation for non-owners.
3Productivity
If worksheets are copied for referencing, then access efficiency is improved, but data consistency may deteriorate
Solution Approach 1:
The system creates lightweight copies of worksheets for non-owner access. These copies contain the necessary data and structure for viewing and additive editing without containing the full original worksheet. This copying approach improves access efficiency while the restricted permission model maintains data consistency by preventing modifications that would affect the original.
Solution Approach 2:
The worksheet data is segmented into different access layers: the original worksheet retains full integrity, while lightweight copies provide access to non-owners with restricted capabilities. This segmentation allows efficient access through copies while preserving the stability and consistency of the original data structure.
Data Source
AI summary
Using lightweight references to present a worksheet including receiving, from a first user account, a request for a worksheet presenting a data set from a database, wherein the worksheet was generated by a second user account; determining that the request was not generated from the second user account; and in response to the determination that the request is not from the second user account, presenting the worksheet in a view mode, wherein permissions in the view mode prevent destructive edits to the worksheet and allow additive edits to the worksheet.