Row Access Control

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.

Set up row access control

1. Add

1. Enable the Add Rows toggle button to allow users to add new rows to the table.

Enable adding rows

1. 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.

Allow specific users to add rows

1. Click on Save to apply changes.

Save settings

2. Update

1. Enable the Update Rows toggle button to allow users to modify existing rows.

Enable update option

1. 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.

Allow all users to update rows

• 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.

Allow specific users to update rows

• 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.

Add rule

-> Enter the rule name, the filter criteria, and the designated users who can update these rows. Click on Add.

Configuring criteria for a rule

-> You can add more filter criteria within a rule by clicking on Add filter and then combine them using AND or OR operators.

Adding more criteria within a rule

-> You can set as many rules as required and assign corresponding users for each.

Adding multiple rules

1. Click on Save to apply changes.

Save settings

3. Delete

The 'Delete Rows' toggle is disabled by default.

1. Enable the Delete Rows toggle button to allow users to delete rows from the table.

Enable delete option

1. 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.

Allow all users to delete rows

• 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.

Allow only specific users to delete rows

• 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.

Add rule for delete access

-> Enter the rule name, the filter criteria, and the designated users who can delete these rows. Click on Add.

Configuring criteria for a rule

-> You can add more filter criteria within a rule by clicking on Add filter and then combine them using AND or OR operators.

Adding more criteria within a rule

-> You can set as many rules as required and assign corresponding users for each.

Adding multiple rules

1. 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.

Choose the delete type

1. Click on Save to apply changes.

Save settings

Delete Type

3.1. Delete row permanently

When you select this option, the deleted rows are removed from the table/database permanently.

Delete row permanently

3.2. Mark row as deleted

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.

Mark row as deleted

Show deleted rows

When the 'Show deleted rows' option is selected, the deleted rows are shown in the table in a greyed-out format.

Show deleted rows

When this option is unchecked, the deleted rows are hidden from the table.

Deleted rows are hidden

You can use the audit log to keep track of all changes, including the list of deleted and soft-deleted rows.

Audit log

Soft delete is not supported if Type 2 SCDs are configured in the table. Instead, the deleted rows are struck off.

In the table below, Type 2 SCDs are configured, and the deleted rows are indicated as shown below:

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.