Row Access Control
Last updated
Last updated
Data security and integrity are critically important, especially in a collaborative environment where multiple users work on a shared database. EDITable addresses your security needs by offering row-level access control at the granular level.
You can precisely manage who can add, update, or delete rows by specifying their email IDs. This section explains how you can allow/restrict all or specific users from performing specific actions (add/update/delete) using the 'Row Access Control' in EDITable.
Columnar ACL (access control for columns) is also available in EDITable and has been explained in the Column Access Control section.
To manage permissions for adding, updating, and deleting rows within a table, go to Settings -> Row Access.
Enable the Add Rows toggle button to allow users to add new rows to the table.
Access Control
Under the 'Apply to' section, you can choose to allow all users or only specific users in the workspace to add rows.
All users in this workspace: Select this option to allow all workspace users to add records.
Specific users in this workspace: Choose this option to allow only specific workspace users to add rows. You can enter the email IDs of the users or the AD groups you want to allow.
Click on Save to apply changes.
Enable the Update Rows toggle button to allow users to modify existing rows.
Access Control
Under the 'Apply to' section, you can specify the access rules for the update operation.
All users in this workspace: Select this option to allow all workspace users to update records.
Specific users in this workspace: Choose this option to allow only certain workspace users to update the rows. Enter the email IDs of the users you want to allow.
Rule-based access: Select this option to configure rules governing the update access to particular columns or records in the table based on specified filter criteria.
-> Click on Add Rule to add a rule.
-> Enter the rule name, the filter criteria, and the designated users who can update these rows. Click on Add.
-> You can add more filter criteria within a rule by clicking on Add filter and then combine them using AND or OR operators.
-> You can set as many rules as required and assign corresponding users for each.
Click on Save to apply changes.
The 'Delete Rows' toggle is disabled by default.
Enable the Delete Rows toggle button to allow users to delete rows from the table.
Access Control
Under the 'Apply to' section, you can choose to allow all users or only specific users in the workspace to delete rows.
All users in this workspace: Select this option to allow all workspace users to delete records.
Specific users in this workspace: Choose this option to allow only specific workspace users to delete rows. You can enter the email IDs of the users or the AD groups you want to allow.
Rule-based access: Select this option to configure rules governing the delete access to particular columns or records in the table based on specified filter criteria.
-> Click on Add Rule to add a rule.
-> Enter the rule name, the filter criteria, and the designated users who can delete these rows. Click on Add.
-> You can add more filter criteria within a rule by clicking on Add filter and then combine them using AND or OR operators.
-> You can set as many rules as required and assign corresponding users for each.
Choose the delete type. When you allow users to delete rows, you can let them delete the rows permanently or set up a soft delete. Both methods are explained below in detail.
Click on Save to apply changes.
When you select this option, the deleted rows are removed from the table/database permanently.
When you select this option, the deleted rows remain in the database but are marked as deleted in the table.
This is accomplished by setting a specific value to an existing column in the table when a row is deleted. For example, in the example below, we have assigned the text 'DELETED_ROW' to the deleted row's 'Active' column. The results are displayed below.
When the 'Show deleted rows' option is selected, the deleted rows are shown in the table in a greyed-out format.
When this option is unchecked, the deleted rows are hidden from the table.
You can use the audit log to keep track of all changes, including the list of deleted and soft-deleted rows.
Soft delete is not supported if Type 2 SCDs are configured in the table. Instead, the deleted rows are struck off.
In addition to row-level access control, you can also set up approval workflows so that every change made by a user goes through a review and approval process. This is explained in the next section.
