From 17df7aa5142e7336cdab3f5551ccd3fa66ce7c87 Mon Sep 17 00:00:00 2001 From: Roy Ben-Shabat Date: Mon, 18 Nov 2019 17:34:53 +0200 Subject: Added BackupUser creation to environment creation sequence on Notes. --- .../Notes/Tango.Notes/Azure/New Environment.txt | 12 ++++++++++++ 1 file changed, 12 insertions(+) (limited to 'Software/Visual_Studio/Notes/Tango.Notes/Azure') diff --git a/Software/Visual_Studio/Notes/Tango.Notes/Azure/New Environment.txt b/Software/Visual_Studio/Notes/Tango.Notes/Azure/New Environment.txt index e3e7191ae..dd0e4174e 100644 --- a/Software/Visual_Studio/Notes/Tango.Notes/Azure/New Environment.txt +++ b/Software/Visual_Studio/Notes/Tango.Notes/Azure/New Environment.txt @@ -24,6 +24,18 @@ GO ALTER ROLE db_datawriter ADD MEMBER [Tango DEV]; GO +8.1 Create the backup user using the following script + +CREATE USER [BackupUser] FOR LOGIN [BackupUser] WITH DEFAULT_SCHEMA=[dbo] +GO + +EXEC sp_addrolemember N'db_owner', N'BackupUser' +EXEC sp_addrolemember N'db_accessadmin', N'BackupUser' +EXEC sp_addrolemember N'db_securityadmin', N'BackupUser' +EXEC sp_addrolemember N'db_backupoperator', N'BackupUser' +EXEC sp_addrolemember N'db_datareader', N'BackupUser' +EXEC sp_addrolemember N'db_datawriter', N'BackupUser' + 9. Create a new storage blob container for the machine studio versions. 10. Create a new storage blob container for the PPC versions. -- cgit v1.3.1