Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: ✅ SQL analytics endpoint and Warehouse in Microsoft Fabric
This article details the permissions that workspace roles provide in SQL analytics endpoint and Warehouse. For instructions on assigning workspace roles, see Give users access to workspaces.
Workspace roles
Assigning users to the various workspace roles provides the following capabilities:
| Workspace role | Description |
|---|---|
| Admin | Grants the user CONTROL access for each Warehouse and SQL analytics endpoint within the workspace, providing them with full read/write permissions and the ability to manage granular user SQL permissions. Allows the user to see workspace-scoped session, monitor connections and requests in DMVs via TSQL, and KILL sessions. |
| Member | Grants the user CONTROL access for each Warehouse and SQL analytics endpoint within the workspace, providing them with full read/write permissions and the ability to manage granular user SQL permissions. |
| Contributor | Grants the user CONTROL access for each Warehouse and SQL analytics endpoint within the workspace, providing them with full read/write permissions and the ability to manage granular user SQL permissions. |
| Viewer | Grants the user CONNECT and ReadData permissions for each Warehouse and SQL analytics endpoint within the workspace. Viewers have SQL permissions to read data from tables/views using T-SQL. For more information, see SQL granular permissions in Microsoft Fabric. |