User with contributor role on Resource group can't query on Synapse Studio

Daniel MG 21 Reputation points


...and thanks in advance. I've just joined some users to a resource group that includes a Synapse workspace.
I've added them as contributors in the whole resource group and they can access to the Synapse Studio but they has no access to the whole objects in the workspace to make queries.


If I try to add them through the *Access Control *in Synapse Studio the new button appears greyed out, and I don't know if there is another method to join them or is some kind of limitation.


Someone could help me?


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,477 questions
0 comments No comments
{count} votes

Accepted answer
  1. PRADEEPCHEEKATLA-MSFT 79,946 Reputation points Microsoft Employee

    Hello @Daniel MG ,

    Welcome to the Microsoft Q&A platform.

    UPDATE: This has confirmed as the product-bug. After investigation, the product group deployed a hotfix to fix this problem.

    I would suggest you to refresh the browser and check whether it works.


    User with contributor role doesn’t include granting access on the Access control tab.


    In Synapse Studio, specific buttons or options may be grayed out or a permissions error may be returned when attempting an action if you don't have the required permissions.

    If a button or option is disabled, hovering over the button or option shows a tooltip with the required permission. Contact a Synapse Administrator to assign a role that grants the required permission.

    You can see the roles that provide specific actions here.

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


    • Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification.

0 additional answers

Sort by: Most helpful