Events
31 Mar, 23 - 02 Apr, 23
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
In this tutorial, you'll learn how to add an administrator to your Synapse workspace. This user has full control over the workspace.
So far in the get started guide, we've focused on activities you do in the workspace. Because you created the workspace in STEP 1, you're an administrator of the Synapse workspace. Now, we'll make another user Ryan (ryan@contoso.com
) an administrator. When we're done, Ryan will be able to do everything you can do in the workspace.
Open the Azure portal and open your Synapse workspace.
On the left side, select Access control (IAM).
Select Add > Add role assignment to open the Add role assignment page.
Assign the following role. For detailed steps, see Assign Azure roles using the Azure portal.
Setting | Value |
---|---|
Role | Owner |
Assign access to | USER |
Member | ryan@contoso.com |
Select Save.
Assign to ryan@contoso.com
to the Synapse Administrator role on the workspace.
ryan@contoso.com
to the Synapse Administrator role.Open the workspace's primary storage account in the Azure portal.
On the left side, select Access control (IAM).
Select Add > Add role assignment to open the Add role assignment page.
Assign the following role. For detailed steps, see Assign Azure roles using the Azure portal.
Setting | Value |
---|---|
Role 1 | Owner |
Role 2 | Azure Storage Blob Data Contributor |
Assign access to | USER |
Member | ryan@contoso.com |
Assign ryan@contoso.com
to the db_owner on each dedicated SQL pool in the workspace.
CREATE USER [ryan@contoso.com] FROM EXTERNAL PROVIDER;
EXEC sp_addrolemember 'db_owner', 'ryan@contoso.com'
Events
31 Mar, 23 - 02 Apr, 23
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Secure data and manage users in Azure Synapse serverless SQL pools - Training
Secure data and manage users in Azure Synapse serverless SQL pools
Certification
Microsoft Certified: Azure Administrator Associate - Certifications
Demonstrate key skills to configure, manage, secure, and administer key professional functions in Microsoft Azure.