1 files changed, 12 insertions, 0 deletions
diff --git a/Software/Visual_Studio/Azure/Tango.AzureUtils/Database/DatabaseManager.cs b/Software/Visual_Studio/Azure/Tango.AzureUtils/Database/DatabaseManager.cs
index cb1a608a8..75a7f321b 100644
--- a/Software/Visual_Studio/Azure/Tango.AzureUtils/Database/DatabaseManager.cs
+++ b/Software/Visual_Studio/Azure/Tango.AzureUtils/Database/DatabaseManager.cs
@@ -198,6 +198,18 @@ namespace Tango.AzureUtils.Database
             }
         }
 
+        public async Task AddTangoWebAppUser(String address, String databaseName, String userName, String password)
+        {
+            OnProgress(AzureUtilsStage.Database, $"Adding Tango WebApp permissions on '{databaseName}'...");
+
+            using (DbManager db = DbManager.FromCredentials(address, databaseName, userName, password))
+            {
+                await db.ExecuteCommandAsync("CREATE USER [Tango] FOR LOGIN [BackupUser] WITH DEFAULT_SCHEMA=[dbo]");
+                await db.ExecuteCommandAsync("EXEC sp_addrolemember N'db_datareader', N'Tango'");
+                await db.ExecuteCommandAsync("EXEC sp_addrolemember N'db_datawriter', N'Tango'");
+            }
+        }
+
         #endregion
 
         #region Versions