Add Azure Active Directory user to Azure SQL

First of all, you need to add an Azure Active Administrator to the SQL

In SQL studio to add user/groups:

CREATE USER [Team_xyz] FROM EXTERNAL PROVIDER;
EXEC sp_addrolemember db_owner, [Team_xyz];

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.