Online Data Processing with Row-and-Column Permission Filtering
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current data collaboration systems face challenges in improving collaboration efficiency and security, particularly in managing user permissions for data access and editing, especially in online environments.
Innovation Solution
An information processing method and apparatus that adjusts data information based on user identity and read/edit permissions, allowing for shielding or deleting data without permissions, and enabling online collaboration with row and column data information adjustments.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If data collaboration is enabled for online tables, then data sharing and processing efficiency are improved, but data security and permission management become more difficult to control
Solution Approach 1:
The patent segments data access control into row-level permissions and column-level permissions. Row permissions control which rows a user can access, while column permissions control which columns are visible and editable. This segmentation allows fine-grained control over data access, enabling efficient collaboration while maintaining security by allowing users to access only specific portions of the data they are authorized for.
Solution Approach 2:
The patent implements local quality control by allowing different users to have different visibility and edit rights for different columns in the same table. Instead of uniform access control, the system provides tailored access permissions at the column level, so that each user sees and can edit only the columns relevant to their role, balancing collaboration efficiency with data security.
2Reliability
If column data information is adjusted based on read permission by shielding or deleting data, then data security is improved, but data completeness and user access experience deteriorate
Solution Approach 1:
The patent introduces a permission system as an intermediary layer between the complete data and the user. Instead of directly deleting or shielding data from users, the system uses permission rules as a mediator that filters and transforms the data based on user identity and authorization. This intermediary approach maintains data completeness in the system while ensuring users only receive authorized data, balancing security with information accessibility.
3Adaptability or versatility
If permission rules are updated dynamically, then adaptability and security control are improved, but system complexity and processing overhead increase
Solution Approach 1:
The patent implements dynamic permission management where permission rules can be updated in real-time without requiring system restarts or complex reconfiguration. The system dynamically evaluates user identities against updated permission rules to determine data access rights, enabling flexible adaptation to changing organizational needs while managing complexity through automated permission evaluation mechanisms.
Data Source
AI summary
The present disclosure provides an information processing method and apparatus, a terminal, and a storage medium. The information processing method comprises: according to an information read request of a client, determining a user identity corresponding to the client, first data information requested to be read, and a read permission corresponding to the user identity; generating adjusted first data information on the basis of the user identity, the first data information, and the read permission; and sending the adjusted first data information to the client. The column data information in the present disclosure is allowed to be adjusted on the basis of the read permission, and compared with a solution that a permission can only be set for the row data information, the security of the data information is better improved.