Set a Synapse workspace's SQL Entra ID admin
One step with Microsoft Azure. We can help you get access.
Get something done
Set a Synapse workspace's SQL Entra ID admin
with Microsoft Azure
Use Microsoft Azure: its Microsoft Azure Workspaces API lets you set a Synapse workspace's SQL Entra ID admin in a single step (PUT /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Synapse/workspaces/{workspaceName}/sqlAdministrators/activeDirectory). capabilities.work can help you get signed up and connected.
- How do I assign a SQL Active Directory admin for a Synapse workspace's SQL pools?
- Can I change who administers SQL in my Synapse workspace through Entra ID?
Say it to your AI assistant
- Assign {admin} as the administrator for SQL pools in Synapse workspace {workspace}.
- Make {admin} the SQL AD administrator for Synapse {workspace}.
For your developer
PUT /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Synapse/workspaces/{workspaceName}/sqlAdministrators/activeDirectory in Microsoft Azure Workspaces API. Full spec on APIs.io.