# Row Permissions To set row-level permissions to your table, click on the **Set up** tab and choose **Manage Access.**

The 'Manage Access' window opens:

With 'Row Access' section, you can specify users who can add, update or delete rows. ## 1. Add new rows Under the 'Add' section, you can specify who is allowed to add rows in the workspace. Here are the available options: **No one:** Select this option 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 apply changes. ## 2. Update existing rows 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.

Allow all workspace 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 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. The criteria for updating these rows can be established using column dimensions, allowing for a customized approach to data management and security.

1. Click on **Add Rule** to add a rule.

2. Enter the rule name, the filter condition, and the designated users who can update the rows for these dimensions. Click on **Add.**

3. 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 than one condition in a rule

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

5. Click **Save** to apply changes. ## 3. Delete rows Under the 'Delete' section, you can specify which workspace users can delete rows. **No one:** Choose this option to prevent users from deleting rows.

**All users in this workspace:** Select this option to allow all workspace users to delete records.

Allow all workspace users to delete rows

{% hint style="info" %} You have two options when allowing users to delete rows: either set up a **soft delete** or let them **remove the rows permanently**. Refer to [this section](#delete-type) to know more. {% endhint %} **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 that specify the conditions under which a user or an Active Directory (AD) group can delete rows in the table. The criteria for deleting these rows can be established using column dimensions, allowing for a customized approach to data management and security. 1. Click on **Add Rule** to add a rule.

2. Enter the rule name, the filter condition, and the designated users who can delete these rows. Click on **Add.**

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

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

5. Click **Save** to apply changes. ## Delete Type With the 'Delete Type' option, you can configure whether users can delete rows permanently or do a soft delete.

**Permanent (Hard Delete):** When you select this option, the deleted rows are removed from the table or database permanently. **Mark as Deleted (Soft Delete):** When you select this option, the deleted rows remain in the database but are marked as deleted. This process involves setting a specific value to an existing column of the table when a row is deleted. For instance, we assign the value 'DELETED' to the 'Status' column for the rows that have been deleted.

The deleted rows in the table look as below, after saving your changes:

**Note:** In the above example, a new column called 'Status' has been created using the 'Add Database Column' option 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. This is explained in [this section](broken://pages/TKIqzng0msYl6vYq23R7). --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.powertable.com/explore-powertable/access-control/row-permissions.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.