Add user to Azure SQL Db

— On Master DB
CREATE LOGIN test
WITH PASSWORD = ‘340$Uuxwp7Mcxo7Khy’

— On Cutom DB
— add user
CREATE USER [test]
FOR LOGIN [test]
WITH DEFAULT_SCHEMA = dbo;

— add user to role(s) in db
ALTER ROLE db_owner ADD MEMBER [test];

https://www.mssqltips.com/sqlservertip/5242/adding-users-to-azure-sql-databases/