Create a User in Azure SQL Database

• Wecks

  Right there with Babe

  Points: 780

  More actions

  August 6, 2020 at 2:55 pm

  #3777877

  I need to create a user in Azure SQL Database and map the user to a specific database.

  does anyone have the syntax to make this happen?

  The GUI is restricted and you cant do it as you would in SSMS on-prem as you cant view the properties.

  Also I am after a decent script to check the mappings specifically for an Azure SQL DB.

  Thanks

   

   

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  August 6, 2020 at 4:12 pm

  #3777907

  It would depend on what type of user you are creating - contained? Mapped to a login? There are different options. You  can find examples of the different types in the following article:

  Adding Users to Azure SQL Databases

  Sue

• Wecks

  Right there with Babe

  Points: 780

  More actions

  August 21, 2020 at 8:08 am

  #3782175

  Mapped to a login.

   

• Ant-Green

  SSC Guru

  Points: 113542

  More actions

  August 21, 2020 at 8:28 am

  #3782176

  SQL authentication or Windows authentication?

  Your Azure subscription is tied to your Azure AD/On-Prem synced service for AD auth etc to do Windows?

  If your integrating with AzureAD you want to look at the CREATE LOGIN FROM EXTERNAL PROVIDER syntax.

  For SQL based, the link Sue posted with give you the code to create a SQL authenticated login and user.

• Bradlyrt

  Grasshopper

  Points: 12

  More actions

  August 25, 2021 at 12:07 pm

  #3923832

  If you're integrating with AzureAD you want to look at the CREATE LOGIN FROM EXTERNAL PROVIDER syntax.