Workspace roles in Lakehouse

Workspace roles define what user can do with Microsoft Fabric items. Roles can be assigned to individuals or security groups from workspace view. See, Give users access to workspaces.

The user can be assigned to the following roles:

  • Admin
  • Member
  • Contributor
  • Viewer

In a lakehouse the users with Admin, Member, and Contributor roles can perform all CRUD operations on all data. A user with Viewer role can only read data stored in Tables using the SQL analytics endpoint.

Important

When accessing data using the SQL analytics endpoint with Viewer role, make sure SQL access policy is granted to read required tables.