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'