How do I let other users access my Azure Database

0 votes

I have created an application that has an SQL database in my Azure account. I want to give an external user access to my database, by creating a SQL username and password.. I have allowed this user's IP.  Where exactly can I create the credentials for the new user to access the master database?

Jan 23, 2020 in Azure by anonymous
• 19,610 points
324 views

1 answer to this question.

0 votes

You don't have to grant the user access to the Master database. alternatively, you can connect to the target database as an administrator and add the user using CREATE USER

CREATE USER UserName WITH PASSWORD = 'password123'

For more info refer https://docs.microsoft.com/en-us/azure/sql-database/sql-database-manage-logins

answered Jan 23, 2020 by Sirajul
• 59,050 points

Related Questions In Azure

0 votes
1 answer

How do disconnect to Azure SQL database if I can't access it?

Based on info  from Microsoft, I think ...READ MORE

answered Apr 26, 2019 in Azure by p
• 1,960 points
349 views
+1 vote
2 answers

How do I establish an connection to Azure IoT Hub? Say a connection like MQTT/AMQP using Python.

Azure IoT Hub comes with 3 SDK's: Service SDK Device ...READ MORE

answered Apr 13, 2018 in Azure by null_void
• 3,220 points
1,164 views
0 votes
4 answers

How can I rename a SQL Azure database?

This command serves the purpose ALTER DATABASE [oldname] ...READ MORE

answered Nov 30, 2018 in Azure by Abhinav
999 views
0 votes
2 answers

How can I download a .vhd image to my local machine from azure and upload the same to a different azure account?

From the Windows Azure Portal you can ...READ MORE

answered Aug 20, 2018 in Azure by Priyaj
• 58,120 points
10,396 views
0 votes
1 answer

Resource group in Azure.

An Azure resource group is a way ...READ MORE

answered Jan 20, 2020 in Azure by Sirajul
• 59,050 points
107 views
0 votes
1 answer
0 votes
1 answer