Adding a SQL User to an Azure SQL Database

  • From Visual Studio, Connect to the Azure SQL Database using Sql Server Object Explorer
  • New Query…
CREATE LOGIN [biz-crm] WITH PASSWORD ='StrongPasswordWithDigitsAndSymbols0192837493~@()&%£*($&)$*£(';  
CREATE USER [biz-crm]  FROM LOGIN [biz-crm];  
ALTER ROLE db_datareader ADD MEMBER [biz-crm];  
ALTER ROLE db_datawriter ADD MEMBER [biz-crm];  

Reference

Scroll to Top