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
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
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'.
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
11 people are following this question.