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
• 9,300 points
87 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
• 48,530 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 Prerna
• 1,940 points
128 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
716 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
523 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,530 points
4,511 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer