Create User in Azure AD B2C / Create User in Azure Active Directory

Question

I'm trying to figure out how I can have a user created in Azure AD so they have access to a SQL Azure Database when they sign up to my app using Azure B2C which they can sign up using (Google, Facebook, i.e....) One they sign up can I use something like an Azure function to create the user in Azure AD using the details that were gathered when they signed up through the Azure B2C sign up process?

Answer 1

Using PowerShell script, you can automate the new user creation in Azure AD with Azure Functions.

Refer to this link to learn more about creating new user with Azure Functions.

Create a User with Azure Function | StarWind Blog starwindsoftware.com

You also need to add this user as an external provider in Azure SQL database.

CREATE USER [YourAzureAdUser] FROM EXTERNAL PROVIDER