Set up row and column access control

Data security and integrity are essential in collaborative environments where multiple users work on a shared database. PowerTable addresses your security requirements by enabling you to configure permissions for rows and columns at a granular level.

In this section, you learn how to set row and column access control permissions for your PowerTable app to ensure database security.

• You'll use the Manage Access menu to set row and column permissions, allowing or restricting specific users from performing certain actions (add, update, or delete).

• You can also set up rule-based access to rows and columns to further customize permissions.

Click Setup > Manage Access.

Row Access

Add

In Row Access, under the Add section, you can specify who is allowed to add rows to the table.

• No one: Select this to prevent users from adding new rows to your table.

• All users in this workspace: Select this option to allow everyone in the workspace to add records.

• Specific users: Choose this option to allow only certain users to add rows. Enter the email IDs of the users or the Active Directory (AD) groups you wish to grant access.

Click Save to save and close the window.

Update

In the Update section, you can specify who has permission to update existing rows.

• No one: Choose this option to prevent users from updating rows.

• 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 or the AD groups you want to allow.

• Rule-based access: Select this option to configure rules that specify the conditions under which a user or an Active Directory (AD) group can update rows in the table.

Click Add Rule. Enter a name for the rule. Configure the filter criteria for the rule and add the required users. Only the designated user(s) can update product records that meet the configured condition.

You can configure multiple conditions and combine them using AND or OR.

You can create multiple rules based on specific criteria and assign the appropriate users to each rule. Click Save.

Delete

Similarly, in the Delete section, you can specify which workspace users can delete rows.

Delete Type

With the Delete Type option, you can configure whether users can delete rows permanently or do a soft delete.

Permanent (Hard Delete): If you select this option, the deleted rows are removed from the database permanently.

Mark as Deleted (Soft Delete): If you select this option, the deleted rows remain in the database but are marked as deleted. When a row is deleted, a specific value is assigned to an existing table column.

For instance, you assign the value DELETED to the Status column for the rows that have been deleted.

Deleting a row does not delete it; instead, it marks it as deleted.

Note

In the above example, a new column called Status has been created using Add Database Column to track deleted rows.

Show Deleted rows

While soft-deleting rows, if the Show Deleted rows option is selected, the deleted rows are shown as above in a grayed-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 permanently deleted and soft-deleted rows.

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.

After configuring the add, update, and delete permissions, click Save.

Column Access

Just as you can configure row permissions, you can also set column permissions.

By default, all workspace users who have access to the PowerTable item can view and modify all columns.

To set up access permissions to the columns,

1. Click on Setup > Manage Access.

2. Choose Column Access.

3. To set permissions for a column, enter the name or email ID of the users to whom you wish to provide the access in the Who Can Edit field.

1. You can add multiple users. You can also enter the email ID of an organizational group or an Active Directory list.

2. Clear Allow Edits to prevent users from editing specific columns, such as sensitive data or critical information that should remain unchanged. As a best practice, keep the primary key field locked so that it cannot be edited.

3. Click Save to save the settings.