Revision history [back]

To include Azure AD groups into an Azure SQL database, follow these steps:

1. Create an Azure SQL database or use an existing one.

2. Open the Azure portal and navigate to the SQL database.

3. Click on "Access control (IAM)".

4. Click on "+ Add" and select "Add role assignment".

5. In the "Add role assignment" window, select the role you want to assign to the Azure AD group (such as "Reader" or "Contributor").

6. In the "Select" dropdown, choose "Azure AD group" and enter the name of the group you want to assign the role to.

7. Click on "Save".

Now, the Azure AD group has access to the Azure SQL database with the assigned role.