azure synapse RBAC not working

MrFlinstone 501 Reputation points
2024-05-30T22:05:59.0533333+00:00

I have just created a synapse analytics workspace, on opening it I get an error message similar to the below.

taT7uZyf.png (1381×446)

From my research, I have gr anted storage blob contributor role to the synapse application as well as the user assigned managed identity.

Going into Manage >> Access Control, I cannot seem to assign roles.

I expect a screen with all the assignment roles, but I get the below

lG6anWJ9.png (1291×640)

Is there a way to view the actual error message to see what is causing the problem ?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,553 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Smaran Thoomu 11,370 Reputation points Microsoft Vendor
    2024-05-31T11:07:40.3666667+00:00

    Hi @MrFlinstone

    Thank you for reaching out to the community forum with your query.

    Regarding your unauthorized status, it seems you don't have sufficient permissions to view the pools in Synapse Studio. You will need either Synapse Administrator or Synapse SQL Administrator permissions. If you don't have these permissions, please follow the instructions in the image below to have your login added to the required role.

    User's image

    Regarding the issue with assigning role, it's possible that you don't have the necessary permissions to assign roles in the Synapse workspace. To assign roles, you need to have the Owner or User Access Administrator role in the Azure subscription. If you don't have these roles, you can ask your Azure administrator to grant you the necessary permissions.

    If you have the necessary permissions but still can't assign roles, try using Azure PowerShell or Azure CLI to do it. Here's an example command to assign the Storage Blob Data Contributor role to a user:

    New-AzRoleAssignment -ObjectId <User Object ID> -RoleDefinitionName "Storage Blob Data Contributor" -Scope <Workspace Resource ID>
    
    

    Replace <User Object ID> with the user's object ID and <Workspace Resource ID> with your Synapse workspace's resource ID.

    Another possible reason is this could be an intermittent issue while opening synapse workspace. You can also try logging in manually at https://web.azuresynapse.net and signing into your workspace.

    Hope this helps. Do let us know if you any further queries.


    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.