diff options
| author | Roy Ben Shabat <Roy.mail.net@gmail.com> | 2020-02-25 16:25:40 +0200 |
|---|---|---|
| committer | Roy Ben Shabat <Roy.mail.net@gmail.com> | 2020-02-25 16:25:40 +0200 |
| commit | 0523d927f31acc3be070fa6281c3108aaefe65c2 (patch) | |
| tree | 3467788bf39bd919977d2a6fa42d62ceda03dc70 /Software/Visual_Studio/Azure/Tango.AzureUtils/Database | |
| parent | 1d2a8fcc28a69b87f8deb3f08323c9a80e3631e2 (diff) | |
| download | Tango-0523d927f31acc3be070fa6281c3108aaefe65c2.tar.gz Tango-0523d927f31acc3be070fa6281c3108aaefe65c2.zip | |
Azure Utils: Added Tango WebApp user creation and permission on database for token authentication.
Also added to Azure notes.
Diffstat (limited to 'Software/Visual_Studio/Azure/Tango.AzureUtils/Database')
| -rw-r--r-- | Software/Visual_Studio/Azure/Tango.AzureUtils/Database/DatabaseManager.cs | 12 |
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 |