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 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.
Click on Save to apply changes.
Enable the Update Rows toggle button to allow users modify existing rows.
Access Control: Under the 'Apply to' section, you can either allow all users or only specific users in the workspace to update the rows.
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 either allow all users or only specific users in the workspace to delete rows.
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.
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 Subcategory 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.
