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 in Azure by anonymous
• 19,080 points
250 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 by Sirajul
• 58,130 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
249 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
969 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
852 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
• 57,700 points
8,540 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer