Administrator login in Azure SQL DB

Consider the database name is ‘test’. Connect to ‘master’: CREATE LOGIN login1 WITH password='<ProvidePassword>’; CREATE USER login1User FROM LOGIN login1; EXEC sp_addrolemember ‘dbmanager’, ‘login1User’; — if the database level permission are needed for the login ‘login1user’ EXEC sp_addrolemember ‘loginmanager’, ‘login1User’; — if this login should be able to create and manage other logins Now connect…