Tables permissions and roles

You can set table permissions to determine which users can access tables and the table data.

• Automation permissions: To set table permissions for Nintex Workflow users.

• App permissions: To set table permissions for Nintex Apps users.

Table permissions determines which users can access tables and data. The available roles and their descriptions are shown below.

Note: Only users with the Table Owner or Table User roles can publish workflows. Users with other roles may be able to view the table in the workflow configuration and use the table when designing workflows, but cannot publish workflows that include the table.

Change table permissions

1. Open the Table permissions panel.
   • On the Tables page, to the right of the table you want, click and select Permissions.
   • Open the table you want and on the toolbar, click Permissions and select Automation permissions.

   Note: Users with a license for Nintex Apps will have access to App permissions as well.

   The Table permissions panel is displayed.

2. In the Add New Role section, select the the roles you want to add.

3. To add users to a role, click the field for the role to open the drop-down.

4. Select one or more groups or users from the list.

   Note: 

   • If a group is assigned the Table Owner role and it contains users with a Participant role, that user will be able to modify the table schema in My Nintex.

   • Only a maximum of 20 users and groups can be added across all roles for a table.

   • If a user is assigned multiple roles or belongs to a group that is assigned to a role, the user inherits the permissions of the highest role.

   • When a group is selected, all members of that group inherit the role’s permissions. For more information about groups, see Create, edit, and manage user groups.

   View the members of a group

   1. Open the User management page: On the top navigation bar, click Settings.

   2. On the left navigation, click User management.

   3. In the Groups section, open the Member(s) drop-down to view group members.

5. (Optional) Enable the Allow authenticated user access toggle to allow all authenticated users to have read access to this table. Form users are will also be able to read and select data variables that have been configured using the table.

6. Click Apply.

   Note: 

   • You must assign at least one user or group to each role to enable the Apply button to save changes.

   • To delete a role, click next to the role name.

Roles and descriptions

Role		Description
Designer roles	Table owners	Full write access to the table, including its schema, data, and permissions. Only owners can create a Form on a table. Can also edit via the grid when there is a Form attached. Participants can be assigned as Table owners. This grants them access to Table Owner features in My Nintex.
	Table Users	Can reference and use the table in workflows and forms. Table Users also have read access to the table.
Full table access roles	Data Readers	Can read all rows in the table including data export.
	Data Editors	Can create, read and edit all rows in the table including export and import.
	Data Owners	Full control of the data, including the ability to create, read, update, and delete all rows in the table. Can also import and export all data and edit via the grid when there is a Form attached.
	Data Creators	Can create new rows in the table but cannot read, edit, or delete any data. The table will not appear in their Tables list.
Own-row access roles	My Data Readers	Can read only the rows they created including data export.
	My Data Contributors	Can create and read only the rows they created including data import and export.
	My Data Editors	Can create, read and edit only the rows they created including data import and export
	My Data Owners	Can create, read, update, and delete only the rows they created including data import and export.

Tables listing capabilities by role

	Table Owners	Table Users	Data Readers	Data Editors	Data Owners	Data Creators	My Data Readers	My Data Editors	My Data Managers	My Data Contributors
Delete table via options menu on tables page	✔	✘	✘	✘	✘	✘	✘	✘	✘	✘
Schema import	✔	✘	✘	✘	✘	✘	✘	✘	✘	✘
Schema export	✔	✘	✘	✘	✘	✘	✘	✘	✘	✘

Tables management capabilities by role

	Table Owners	Table Users	Data Readers	Data Editors	Data Owners	Data Creators	My Data Readers	My Data Contributors	My Data Editors	My Data Owners
Export data	✔	✔	✔	✔	✔	✘	✔	✔	✔	✔
Import data	✔	✘	✘	✔	✔	✘	✘	✔	✔	✔
New table	✔	✘	✘	✘	✘	✘	✘	✘	✘	✘
Assign permissions	✔	✘	✘	✘	✘	✘	✘	✘	✘	✘
Create form	✔	✘	✘	✘	✘	✘	✘	✘	✘	✘
Add columns	✔	✘	✘	✘	✘	✘	✘	✘	✘	✘
Edit column	✔	✘	✘	✘	✘	✘	✘	✘	✘	✘
Delete column	✔	✘	✘	✘	✘	✘	✘	✘	✘	✘
Add row	✔	✘	✘	✔	✔	✔	✘	✔	✔	✔
Modify row	✔	✘	✘	✔	✔	✘	✘	✘	✔	✔
Delete row	✔	✘	✘	✘	✔	✘	✘	✘	✘	✔
Update table details	✔	✘	✘	✘	✘	✘	✘	✘	✘	✘
View access	✔	✔	✔	✔	✔	✘	✔	✔	✔	✔
Add/Edit grid if there's a form	✔	✔	✘	✘	✔	✘	✘	✘	✘	✔
List tables	✔	✔	✔	✔	✔	✘	✔	✔	✔	✔