Umbraco Azure SQL create user

create_user.sql

-- =================================================
-- Create User as DBO template for Windows Azure SQL Database
-- =================================================
-- For login <login_name, sysname, login_name>, create a user in the database


-- EXECUTE THIS ON AZURE MASTER DATABASE
CREATE LOGIN [client-stg-umbraco-user] WITH password='xxx';
GO


-- EXECUTE THIS ON AZURE UMBRACO DATABASE
CREATE USER [client-stg-umbraco-user]
	FOR LOGIN [client-stg-umbraco-user]
	WITH DEFAULT_SCHEMA = [dbo]
GO

-- Add user to the database owner role
EXEC sp_addrolemember N'db_owner', N'client-stg-umbraco-user'
GO