Post reply

Create a User in Azure SQL Database

  • 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

     

     

  • 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

  • August 21, 2020 at 8:08 am

    #3782175

    Mapped to a login.

     

  • 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.

  • September 2, 2020 at 8:22 am

    This was removed by the editor as SPAM

  • September 2, 2020 at 8:23 am

    This was removed by the editor as SPAM

  • September 12, 2020 at 9:14 am

    This was removed by the editor as SPAM

  • October 8, 2020 at 11:35 am

    This was removed by the editor as SPAM

  • October 8, 2020 at 11:37 am

    This was removed by the editor as SPAM

  • October 8, 2020 at 11:37 am

    This was removed by the editor as SPAM

  • November 18, 2020 at 6:22 pm

    This was removed by the editor as SPAM

  • 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.

  • February 1, 2022 at 12:29 pm

    This was removed by the editor as SPAM

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply