Assign roles at table level

Baserow Advanced and Enterprise plans come with advanced user management to boost data protection and privacy requirements. Role-based access control allows administrators to restrict access to data by assigning roles to users in workspaces, databases or tables.

Role based permissions feature is available to users on Baserow.io SaaS Advanced and Self-hosted Enterprise plans. To learn more about Baserow paid plans, visit our pricing page.

An admin can assign roles to Members and/or Teams at the workspace level and on individual databases and tables. This support article covers assigning roles to members individually and teams in bulk on an individual table. For assigning roles for other applications:

• Assign roles to members at workspace level
• Assign roles to teams at workspace level
• Assign roles to teams and members at database level

Table roles will override workspace and database roles. This means that a member who is explicitly assigned a role on a table will get that exact role, regardless of any workspace and database roles. Learn more about the hierarchy of roles.

Manage roles for a specific table

Members with Admin roles at the table level can invite members to a table and assign roles to users.

To manage and assign roles to members or teams on an individual table,

1. Within the database, select a table you’d like to invite the member to

2. Click on the vertical ellipsis beside the table then click “Manage members” from the options dropdown in the sidebar.

   

3. Click “Select Members” on the modal to add roles for individual users and teams on this specific table.

   

4. Search and select the members and/or teams you want to invite to the table using the tick box or the “Select all” button. The modal will indicate the total number of members selected. Learn how to invite members to a workspace or how to create teams.

5. Choose the member’s and/or team’s default role for the specific table. Click the default role drop-down to scroll through the list of permissions.

   

6. Then click the “Invite members/teams” button. The Invite button will indicate the total number selected.

View users’ access in a table

You can see invited users that have access to the table and roles for the specific table on the modal.

Note ⚠️: Other users might inherit access via their respective roles on the parent database or workspace. However, you won’t see users or teams who have inherited permission to see or have access to this table from their parent database or workspace here. You only see exceptions to the workspace or database defaults.

The list of table members is not an exhaustive list of everyone who has a role on that table. It contains only the list of specific role assignments on that specific table. For example, if User A has a workspace level role of Admin, they will be an Admin on all databases and tables, if there are no exceptions added. However, the ‘Table-> Manage Members’ modal will now show User A as an Admin on that table.

Modify or Remove access from a table

Admins can remove access from the Manage members modal.

To remove a member and/or team access from a table,

1. Within the database, select a table you’d like to invite the member to

2. Click on the vertical ellipsis beside the table then click “Manage members” from the options dropdown in the sidebar.

   

3. Remove or modify an existing member’s and/or team’s default role on a specific table by selecting an option from the default role dropdown.

   

If you’re looking for something else, please feel free to make recommendations or ask us questions in our online community—we’re ready to assist you!