Assign table permissions

Table permissions are assigned to web roles to allow members of the web role access to data stored in Dataverse tables.

1. Using the design studio, select Set up workspace.

2. In the Security section, select Table permissions.

3. Select the table permission you want to assign for a web role.

4. In the Roles section, select + Add roles and choose the roles you wish to assign to the table permission. You can select multiple roles.

   

   Important

   When Anonymous users are granted access to a table, any user who visits the site can access data.
   More information: Notifications for Anonymous users web role

5. Select Save.

6. If the web role doesn't appear, select Manage roles to open the Portal Management app to create web roles.

   Note

   Once you have created the web role, select Sync in the design studio and refresh your browser to view your new roles in the table permissions side panel.

Notifications for Anonymous users web role

When the anonymous users web role is selected, your site's data is visible to anyone.

Tip

If your site visibility is set to Public, an icon will appear next to the name field in design studio and the following message will display: The data displayed in your site can be seen by anyone. If that's not what you want, change or eliminate the "Anonymous" role in your table permissions.

To restrict access to your site's data, follow the steps to assign table permissions and remove the checkmark next to the Anonymous users web role.

See also

Configure table permissions
Create web roles
Tutorial: Display data securely on your site