How to authenticate local Users (ASPNERUSERS)

Question

How to authenticate local Users (ASPNERUSERS)

Ramesh Sathiya narayanan 0

I have a scenario, I am using Asp.net Core 6 and Azure.

The Scenario is that I have an IdentityProvider (ASPNETUSERS, ASPNETUSERROLES, etc.) table in an Azure SQL database. Whenever I create a new user, the information gets saved into ASPNERUSERS and related tables. I want to authenticate these users while they log in, and I should generate an on-behalf flow to connect with the API along with a JWT Token.

Can anyone help me achieve this?

Shweta Mathur 30,276 Reputation points Microsoft Employee

2023-07-06T04:57:35.86+00:00

Hi @Ramesh Sathiya narayanan ,

Just checking in to see if the below answer helped. If this answers your query, please don’t forget to click "Accept Answer" which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

1 answer

Your answer

Shweta Mathur 30,276 Reputation points Microsoft Employee

2023-07-06T04:57:35.86+00:00

Hi @Ramesh Sathiya narayanan ,

Just checking in to see if the below answer helped. If this answers your query, please don’t forget to click "Accept Answer" which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Answer 1

Hi @Ramesh Sathiya narayanan

Thanks for reaching out.

To authenticate users in Azure SQL database while they log in and generate an on-behalf flow to connect with the API along with a JWT Token, you can use Azure Active Directory (Azure AD) authentication with Azure SQL Database.

Azure AD authentication provides a way to authenticate users with Azure AD identities and access Azure SQL Database. You can use Azure AD authentication with Azure SQL Database to centrally manage the identities of database users and other Microsoft services in one central location.

To use Azure AD authentication with Azure SQL Database, you need to create an Azure AD application and configure it to access Azure SQL Database. You can then use the Azure AD application to authenticate users and obtain tokens to call APIs protected by Azure AD.

Here are the high-level steps to use Azure AD authentication with Azure SQL Database:

Create an Azure AD application and configure it to access Azure SQL Database.

Configure Azure SQL Database to use Azure AD authentication.

Authenticate users with Azure AD and obtain tokens to call APIs protected by Azure AD.

Use the obtained token to connect to Azure SQL Database.

You can find more information on how to use Azure AD authentication with Azure SQL Database in this document:

https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-configure?view=azuresql&tabs=azure-powershell#azure-ad-token

https://github.com/microsoft/sql-server-samples/tree/master/samples/features/security/azure-active-directory-auth/token

https://learn.microsoft.com/en-us/sql/connect/ado-net/sql/azure-active-directory-authentication?view=sql-server-ver16

Hope this will help.

Thanks,

Shweta

Please remember to "Accept Answer" if answer helped you.

Share via

How to authenticate local Users (ASPNERUSERS)

1 answer

Your answer