question

IRF-4553 avatar image
0 Votes"
IRF-4553 asked AnuragSharma-MSFT commented

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

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

azure-sql-database
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @IRF-4553, please let us know if you need more details on the same. if answer provided by Vaibhav helped. you can mark it as 'Accept Answer'.

0 Votes 0 ·

1 Answer

VaibhavChaudhari avatar image
0 Votes"
VaibhavChaudhari answered

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


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.