CODEWITHSUNDEEP
sql-serverazureazure-sql-databaseazure-synapse
rodneyc8063
rodneyc8063

Reputation: 123

Azure Synapse Serverless SQL Pool Unable to Connect BUT Can connect to Dedicated SQL Pool?

My team is currently test driving Azure Synapse and we are hitting some role permissions that confused us a bit.

I was given the role of "Synapse Contributor" initially so I am able to log into the workspace and look around.

BUT when I try to use the built in serverless SQL pool I hit the following error:

You don't have access to the serverless SQL pool, Built-in. To be granted access, contact a Synapse Administrator for this workspace.

Weird thing is that for a newly created dedicated SQL pool I have no problem accessing it.

Now my admin played around and gave me "Synapse SQL Adminstrator" THEN I was able to access both the serverless and dedicated SQL pools.

So Im a bit concerned as I dont want to be giving out an administrator role to every person that wants to use the serverless SQL pool.

Questions

-Is this "expected"? That anyone needing access to the serverless SQL pool needs to be given this admin role? Or is there some other role or setting we are missing?

-Secondly - How come I am able to access the dedicated SQL pool as a regular Synapse contributor BUT not able to access the serverless SQL pool?

Upvotes: 1

Views: 3618

Answers (1)

SureshBabu
SureshBabu

Reputation: 474

Is this "expected"? That anyone needing access to the serverless SQL pool needs to be given this admin role? Or is there some other role or setting we are missing?

As mentioned in Official document to access Serverless SQL you need either Synapse Administrator or Synapse SQL Administrator role.

See Grant Access to SQL pools for examples of SQL scripts for granting SQL permissions in SQL pools.

How come I am able to access the dedicated SQL pool as a regular Synapse contributor BUT not able to access the serverless SQL pool?

To access Serverless SQL you need either Synapse Administrator or Synapse SQL Administrator role.

To access Dedicated SQL you need either Synapse Administrator or Synapse Contributor role.

See Synapse Roles and Scope for more understanding of Synapse Built-in Roles.

Upvotes: 1

Related Questions