| title | Workspace Roles in Fabric Data Warehouse |
|---|---|
| description | Learn about the roles you can use to manage user access within a workspace. |
| ms.reviewer | cynotebo, jacindaeng |
| ms.date | 06/26/2025 |
| ms.topic | concept-article |
| ms.search.form | Warehouse roles and permissions, Workspace roles and permissions |
Applies to: [!INCLUDE fabric-se-and-dw]
This article details the permissions that workspace roles provide in [!INCLUDE fabric-se] and [!INCLUDE fabric-dw]. For instructions on assigning workspace roles, see Give users access to workspaces.
Assigning users to the various workspace roles provides the following capabilities:
| Workspace role | Description |
|---|---|
| Admin | Grants the user CONTROL access for each [!INCLUDE fabric-dw] and [!INCLUDE fabric-se] 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 and to monitor connections and requests in DMVs via TSQL. |
| Member | Grants the user CONTROL access for each [!INCLUDE fabric-dw] and [!INCLUDE fabric-se] 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 [!INCLUDE fabric-dw] and [!INCLUDE fabric-se] 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 [!INCLUDE fabric-dw] and [!INCLUDE fabric-se] 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. |