How do I let other users access my Azure Database?

Microsoft Azure

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?

1
Answers

Replies

It is not required to grant the user access to the master database. You can also connect to the target database as an administrator and add the user using the create user command, which is represented below.


CREATE USER UserName WITH PASSWORD = 'pass@123'

 
 

If you want to unleash your potential in this competitive field, please visit the Microsoft Azure course page for more information, where you can find the Microsoft Azure tutorials and Microsoft Azure frequently asked interview questions and answers as well.

 

This topic has been locked/unapproved. No replies allowed

Login to participate in this discussion.

Leave a reply

Before proceeding, please check your email for a verification link. If you did not receive the email, click here to request another.