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,580 points

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

answered Jan 23, 2020 by Sirajul
• 58,990 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
+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
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
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,100 points
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer