Assign Azure SQL database permissions to AAD group

When you create a Azure SQL database (DB) right of the bat, you will be faced with the need to assign permission in the database to users or security groups. Normally on a on-prem SQL DB it’s no problem and can be done using the GUI in SSMS. But for a Azure SQL DB, there is no GUI to assign permissions, you you will need to use SQL querys to assign permissions to users or groups. Let me show you how to assign SQL DB permissions to a AAD security group.

Read more