Synapse Studio - 403 Unauthorised - Even with Owner permissions

Alex Driver 1 Reputation point
2022-02-11T15:42:53.813+00:00

I am having trouble access Synapse Studio for a workspace that I have "Owner" permissions to.

173537-image.png

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,346 questions
{count} votes

4 answers

Sort by: Most helpful
  1. Vaibhav Chaudhari 38,561 Reputation points
    2022-02-12T10:20:48.627+00:00
    2 people found this answer helpful.

  2. Gaurav Batta 11 Reputation points
    2022-08-02T00:41:57.147+00:00

    I was able to get the issue resolved by following what @Vaibhav Chaudhari suggested. That is under Synapse Studio > Access Control, I had to explicitly add Synapse Administrator privilege for my AD account's object id as well as the object id of service principal which was used by Terraform to spin up this infrastructure. When I was creating Synapse Workspace through Powershell or Azure Portal I did not had this problem. The problem was only coming when using Terraform to create azure synapse workspace. Using Terraform somehow was missing to provide Synapse Administrator role in Access Control to my account.

    Thanks!

    2 people found this answer helpful.
    0 comments No comments

  3. Hamish MacDonald 1 Reputation point
    2022-07-04T03:47:15.607+00:00

    @Vaibhav Chaudhari was anything further discovered around this issue? I have same issue.

    • guest user in tenancy
    • owner of subscription
    • created synapse analytics workspace
    • get a 403 when try to add another user as admin.

  4. Gaurav Batta 11 Reputation points
    2022-07-25T20:42:13.983+00:00

    I am having same exact problem, I am owner of Synapse Analytics and owner of the subscription.