mssql-dbcreator.sql

CREATE DATABASE ${DB_NAME};
GO
USE ${DB_NAME};
GO
CREATE LOGIN [${DB_USER}] WITH PASSWORD = '${DB_PASSWORD}', CHECK_EXPIRATION = OFF, CHECK_POLICY = OFF;
GO
CREATE USER [${DB_USER}] FROM LOGIN [${DB_USER}];


ALTER SERVER ROLE dbcreator
    ADD MEMBER [${DB_USER}];