From 0523d927f31acc3be070fa6281c3108aaefe65c2 Mon Sep 17 00:00:00 2001 From: Roy Ben Shabat Date: Tue, 25 Feb 2020 16:25:40 +0200 Subject: Azure Utils: Added Tango WebApp user creation and permission on database for token authentication. Also added to Azure notes. --- .../Azure/Tango.AzureUtils/Database/DatabaseManager.cs | 12 ++++++++++++ 1 file changed, 12 insertions(+) (limited to 'Software/Visual_Studio/Azure/Tango.AzureUtils/Database/DatabaseManager.cs') 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 -- cgit v1.3.1