diff options
| -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. |