/*
  Press Ctrl+Shift+M to fill template parameters.
*/

/* RUN THIS IN MASTER DATABASE !!! */
CREATE LOGIN <LoginName,nvarchar,> WITH PASSWORD = N'<Pass,nvarchar,>'
GO

/* RUN THIS IN TARGET DATABASE !!! */
CREATE SCHEMA <SchemaName,nvarchar,>
GO

CREATE USER <UserName,nvarchar,>
	FOR LOGIN <LoginName,nvarchar,>
	WITH DEFAULT_SCHEMA = <SchemaName,nvarchar,>
GO

ALTER AUTHORIZATION ON SCHEMA::<SchemaName,nvarchar,> TO <UserName,nvarchar,>
GO

GRANT CREATE TABLE TO <UserName,nvarchar,>;
GRANT CREATE VIEW TO <UserName,nvarchar,>;
GRANT CREATE PROCEDURE TO <UserName,nvarchar,>;
GRANT CREATE TYPE TO <UserName,nvarchar,>;
GRANT CREATE FUNCTION TO <UserName,nvarchar,>;
GRANT CREATE DEFAULT TO <UserName,nvarchar,>;
GO