Effect on Azure SQL Server DB permissions of Azure Active Directory Group rename

Ruchira Kale 1 Reputation point

I need to rename the AAD group. The users of that group have permissions on Azure SQL server database via Group only( contained user).
1] What will be the effect of renaming the AAD group name on SQL server database permissions?
2] Will the user still have the same permissions?
3] Will the name change of the ADD group will be reflected automatically in Azure SQL database?
4] if it is not reflected automatically then how do I fix it?

Azure Active Directory
Azure Active Directory
An Azure enterprise identity service that provides single sign-on and multi-factor authentication.
16,582 questions
Azure SQL Database
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Nandan Hegde 25,376 Reputation points MVP

    Renaming an AAD group would not have any impact on existing permissions and everything should be same.
    Based on my experience, the name change is not reflected automatically in user details within Azure SQL database/synapse.

    Still get the old names with the below query:

    SELECT r.name role_principal_name, m.name AS member_principal_name
    FROM sys.database_role_members rm
    JOIN sys.database_principals r
    ON rm.role_principal_id = r.principal_id
    JOIN sys.database_principals m
    ON rm.member_principal_id = m.principal_id