Column Permissions

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

By default, all workspace users who have access to the PowerTable item can view and modify all columns. Access control for each column can be configured through the 'Manage Access' menu. Here, you can clearly specify who is allowed to write values to each column.

To set up access permissions to the columns,

  1. Click on the Manage Access menu from the Setup tab.

Manage Access
  1. Choose Column Access tab.

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

In the example below, we are setting access control for the 'Product SKU' column by specifying the users' name.

Specify access control list
  1. You can enter as many users as you want. You can also type in the email ID of your organization group or active directory list.

Access control list who can edit 'Product SKU' column
  1. You can uncheck the 'Allow Edits' checkbox to prevent users from editing specific columns. Typically, the primary key field is locked from editing. Click Save to save the settings.

Save the settings

Last updated