To Create User login and User in Azure SQL server using SQL Server Management Studio(SSMS)
Step 1 : Create user logon from master database
CREATE LOGIN [abc] WITH PASSWORD=N'Password@123'where ‘abc’ is login name
Step 2 : Create User from specific database , where User want to Access
CREATE USER [abc] FOR LOGIN [abc] WITH DEFAULT_SCHEMA=[dbo]Step 3: Grant Connect access to User on specific database to connect database
Grant connect to [abc]Step 4 : if required give db_datareader or db_owner access
exec sp_addrolemember 'db_datareader', 'abc'
