August 6, 2020 at 2:55 pm
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
August 6, 2020 at 4:12 pm
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
August 21, 2020 at 8:08 am
Mapped to a login.
August 21, 2020 at 8:28 am
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.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy