How do I let other users access my Azure Database

Question

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?

Answer 1

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