How to grant admin permission to AAD users in Azure SQL Server

Question

Using portal.azure.com I've created SQL Server and SQL Database. I've set myself as the SQL Server admin.

I'm able to connect with my AAD account using SSMS.

I add another AAD users to my database:

use [MyDatabase]
CREATE USER [usename_emaildomain#EXT#@mydirectory.onmicrosoft.com] FROM EXTERNAL PROVIDER;

--add read permissions
EXEC sp_addrolemember 'db_datareader', [usename_emaildomain#EXT#@mydirectory.onmicrosoft.com]

But how do grant him admin rights so that he has full access to all databases? I'm able to sent only one admin in Azure Portal.

You need to put all users in a group and add that single group rather than a single user. — Nick.Mc, Mar 28 '18 at 10:06

score 1 · Accepted Answer · answered Mar 28 '18 at 11:02

1

I don't know why SQL Azure only allows one security principal to be designated as admin but anyway....

You can assign one user or one group. So put all of your users in a group and assign that group as the administrator

answered Mar 28 '18 at 11:02

Nick.Mc

18,304
6
61
91

How to grant admin permission to AAD users in Azure SQL Server

1 Answers1