Az Active Directory Admin Group Name for Azure Database for PostgreSQL single server supports up to 63 Characters

[arindam0310018]

Hello Team,

Please be informed that when I tried adding Azure Active Directory Group as Admin in Azure Database for PostgreSQL Single Server, it was observed that it supports AAD Group Name up to 63 characters.

If the AAD Group Name is 64 characters and above, it allows be to add and save but as soon as I refresh the page, AAD Group is No more displayed. It only displays "NO ACTIVE DIRECTORY ADMIN"

Below is what I tried and my observation (please correct me if I am wrong)

No. of Characters Supported for AAD Group Name in Az Database for PostgreSQL	Status after Refreshing the Az Portal
69	FAIL - Displays "NO ACTIVE DIRECTORY ADMIN"
40	Success - Displays the AAD GROUP NAME
43	Success - Displays the AAD GROUP NAME
55	Success - Displays the AAD GROUP NAME
61	Success - Displays the AAD GROUP NAME
65	FAIL - Displays "NO ACTIVE DIRECTORY ADMIN"
64	FAIL - Displays "NO ACTIVE DIRECTORY ADMIN"
63	Success - Displays the AAD GROUP NAME
62	Success - Displays the AAD GROUP NAME

There is also NO MENTION of such phenomenon in Limits Page of Az Database for PostgreSQL Single Server - https://learn.microsoft.com/en-us/azure/postgresql/single-server/concepts-limits or in Active Directory Authentication - https://learn.microsoft.com/en-us/azure/postgresql/single-server/how-to-configure-sign-in-azure-ad-authentication

Please let me know.

Awaiting for your response.

Many Thanks
Regards, Arindam Mitra

---

Document Details

⚠ Do not edit this section. It is required for learn.microsoft.com ➟ GitHub issue linking.

• ID: 115c4394-bd60-5f8f-bd88-c76a7c0ee2cd
• Version Independent ID: 87c3407f-8565-e63e-258a-044365f35ad2
• Content: Use Azure Active Directory - Azure Database for PostgreSQL - Single Server
• Content Source: articles/postgresql/single-server/how-to-configure-sign-in-azure-ad-authentication.md
• Service: postgresql
• Sub-service: single-server
• GitHub Login: @sunilagarwal
• Microsoft Alias: sunila

[GeethaThatipatri-MSFT]

@arindam0310018 Thanks for your findings, We will look into it and update as appropriate.

[shaktisingh-msft]

Hi @sunilagarwal,

Could you please look into this document request. Thanks

[arindam0310018]

Hello @GeethaThatipatri-MSFT, @sunilagarwal @shaktisingh-msft,

Request for an update ?

Many Thanks
Regards, Arindam Mitra

[shaktisingh-msft]

Hi @kabharati,

Could you please look into this document request. Thanks

[arindam0310018]

Hi @kabharati,

When you find sometime, please do update!!!

Many Thanks
Regards, Arindam Mitra

[arindam0310018]

Hi @kabharati, @shaktisingh-msft

When you find sometime, please do update!!!

Many Thanks
Regards, Arindam Mitra

[kabharati]

hi @arindam0310018 - I need to validate this but it appears it is error in documentation and currently AAD document suggests 53-character limit which should have been 63 characters. I am following up with AAD team to confirm this.

From PG side we follow AAD limitations.

[arindam0310018]

Hello @kabharati

Thank you for your kind reply.
I look forward for AAD Team`s reply.

Meanwhile, Could you share the link to the documentation which states AAD character limit to 53 characters ?

Many Thanks
Regards, Arindam Mitra

[kabharati]

This is a typo and you're right this should be 63 characters. AAD team is correcting the docs.

[kabharati]

#please-close

[arindam0310018]

Hello @kabharati,
Thank you very much for correcting. Much Appreciated.
Kindly share the link to the documentation, where this was corrected.

Many Thanks
Regards, Arindam Mitra

[kabharati]

Here is the link https://learn.microsoft.com/en-us/azure/active-directory/enterprise-users/groups-naming-policy Get Outlook for iOS<https://aka.ms/o0ukef>

…

________________________________ From: Arindam Mitra ***@***.***> Sent: Friday, November 11, 2022 8:07:40 PM To: MicrosoftDocs/azure-docs ***@***.***> Cc: Kanchan Bharati ***@***.***>; Mention ***@***.***> Subject: Re: [MicrosoftDocs/azure-docs] Az Active Directory Admin Group Name for Azure Database for PostgreSQL single server supports up to 63 Characters (Issue #100012) Hello @kabharati<https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fkabharati&data=05%7C01%7Ckabharati%40microsoft.com%7Cd3fada21f77b42c9191a08dac44a4c1b%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C638038120648945949%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=qMU%2F24CJvwtFr%2B0wDJpwnZRf3j00LzWFdWPRVRKfX6M%3D&reserved=0>, Thank you very much for correcting. Much Appreciated. Kindly share the link where this was corrected. Many Thanks Regards, Arindam Mitra — Reply to this email directly, view it on GitHub<https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FMicrosoftDocs%2Fazure-docs%2Fissues%2F100012%23issuecomment-1312296658&data=05%7C01%7Ckabharati%40microsoft.com%7Cd3fada21f77b42c9191a08dac44a4c1b%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C638038120648945949%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=nE4iTwEok2deZyoKAZZ7ESlJ3dQQ6iPRoYVSl3XD%2Fa8%3D&reserved=0>, or unsubscribe<https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAWEFYP2R6RC6KSDGAMTGHS3WH3UVZANCNFSM6AAAAAARGPRRZE&data=05%7C01%7Ckabharati%40microsoft.com%7Cd3fada21f77b42c9191a08dac44a4c1b%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C638038120648945949%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=inwDejZBnlwpPGrOkOGx11T2MFy8Hgl1aQw%2FjGI0xjk%3D&reserved=0>. You are receiving this because you were mentioned.Message ID: ***@***.***>

[arindam0310018]

Hello @kabharati
Thank you!!!
I can now see the changes made.
Thank you again for making the changes.

Best Regards, Arindam Mitra