diff options
| author | Roy Ben-Shabat <Roy@Twine-s.com> | 2019-11-18 17:34:53 +0200 |
|---|---|---|
| committer | Roy Ben-Shabat <Roy@Twine-s.com> | 2019-11-18 17:34:53 +0200 |
| commit | 17df7aa5142e7336cdab3f5551ccd3fa66ce7c87 (patch) | |
| tree | d3c5f43f41e286a6b89dfd5f8abb7421ab581516 /Software/Visual_Studio/Notes/Tango.Notes/Azure | |
| parent | d50797ddb8c3d886d38a56a09dfe34540512e331 (diff) | |
| download | Tango-17df7aa5142e7336cdab3f5551ccd3fa66ce7c87.tar.gz Tango-17df7aa5142e7336cdab3f5551ccd3fa66ce7c87.zip | |
Added BackupUser creation to environment creation sequence on Notes.
Diffstat (limited to 'Software/Visual_Studio/Notes/Tango.Notes/Azure')
| -rw-r--r-- | Software/Visual_Studio/Notes/Tango.Notes/Azure/New Environment.txt | 12 |
1 files changed, 12 insertions, 0 deletions
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. |