This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 56.00000000000001%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
I am trying using Azure Postgres for my application backend and realize that I can't use username and password I normally use. I need to generate the token and then use token as password.
reference: https://learn.microsoft.com/en-us/azure/postgresql/concepts-aad-authentication
Questions
Is there a way I can use username and password (not token) with Azure AD user or SPN?
If not how to use SPN with my application? how to refresh token?
Does azure postgres local user makes more sense ?
Hello @Shah, Gaurang Thank you for posting your question. Azure AD user authentication will be through AAD. That is right you cannot use username and password.
I am working with PG to check if you can use SPN with your app. I will get back to you.
Regards,
Oury
Hi @Shah, Gaurang You can create user that does not need to be authenticated using AAD. However, if you mark a user to AAD authentication, then that will be the only way.
Regards,
Oury
@Oury Ba-MSFT
Can I have SPN created this way? And how's it's different than local postgres user, will this user be part of AAD but will use some other kind of authentication if so, which? And how can I mark any user/spn to not use AAD Authentication?
Hi @Shah, Gaurang Can I have SPN created this way? Could you please clarify the question?
Regards,
Oury