T-SQL To Create Umbraco Database with separate user

create-umbraco-pre-install.sql

CREATE DATABASE [umbraco-cms];
USE [umbraco-cms];
CREATE LOGIN [Umbraco] WITH PASSWORD = 'mdfS8ryyjwvxhx}r.mdyPjoOms';
ALTER LOGIN [Umbraco] WITH DEFAULT_DATABASE = [umbraco-cms];
ALTER LOGIN [Umbraco] WITH PASSWORD = 'mdfS8ryyjwvxhx}r.mdyPjoOms';
ALTER LOGIN [Umbraco] ENABLE;
GRANT CREATE TABLE TO [Umbraco];
GRANT CREATE VIEW TO [Umbraco];
GRANT SELECT TO [Umbraco];
GRANT DELETE TO [Umbraco];
GRANT UPDATE TO [Umbraco];
GRANT INSERT TO [Umbraco];
GRANT BACKUP DATABASE TO [Umbraco];
GRANT BACKUP LOG TO [Umbraco];
GRANT AUTHENTICATE TO [Umbraco];
GRANT EXECUTE TO [Umbraco];
EXEC sp_AddRoleMember db_accessadmin, [Umbraco];
EXEC sp_AddRoleMember db_owner, [Umbraco];
EXEC sp_AddRoleMember db_ddladmin, [Umbraco];
EXEC sp_AddRoleMember db_datawriter, [Umbraco];
EXEC sp_AddRoleMember db_datareader, [Umbraco];
GO

notes.md

Microsoft Resources Visited

• https://docs.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-2016-from-the-command-prompt
• https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-remote-access-server-configuration-option
• https://docs.microsoft.com/en-us/sql/t-sql/statements/grant-schema-permissions-transact-sql
• https://github.com/Microsoft/sql-server-samples