Synapse User Access Management

Azure Synapse Analytics is the analytics service and fully managed cloud data warehouse. This also means the Synapse will connect the data lake holding the data set regardless of which type of data, which env of data (production). Depending on the industry, it will contain a vast spectrum of transactional, personal, analytical, and so forth data. Then, now you understand how important to have access management to Synapse.

Microsoft proposes the RBAC roles and scopes as built-in roles. https://learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-synapse-rbac-roles.

There are plenty of roles already built-in in the Synapse studio you can manage if you are an owner of the Synapse workspace.

There are interesting notes that you can see. This means if you grant the user permissions in the Synapse studio, the user will have the user role at workspace scope.

Note that you are not going to assign this role to individual users rather you will be requested to have a…