Is it possible to give other people access to my Azure SQL Database?

Question

Can I give my friends access to my Azure SQL Database? If yes how can I do that and how can they connect?

Thank you

Answer 1

Yes, create a user and provide him required access. Login to SSMS using admin credentials and execute below query in the DB where access has to be granted.

With SQL Server name, DB name, user name and password, others can access the DB:

CREATE USER Tom 
WITH PASSWORD = 'YourPassword@1', 
DEFAULT_SCHEMA = dbo; 

-- add user to role(s) in db 
ALTER ROLE db_datareader ADD MEMBER Tom; 

---

Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav