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. --- .../Visual_Studio/Notes/Tango.Notes/Azure/New Environment.txt | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'Software/Visual_Studio/Notes/Tango.Notes') 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 dd0e4174e..710cdcb2d 100644 --- a/Software/Visual_Studio/Notes/Tango.Notes/Azure/New Environment.txt +++ b/Software/Visual_Studio/Notes/Tango.Notes/Azure/New Environment.txt @@ -36,6 +36,14 @@ EXEC sp_addrolemember N'db_backupoperator', N'BackupUser' EXEC sp_addrolemember N'db_datareader', N'BackupUser' EXEC sp_addrolemember N'db_datawriter', N'BackupUser' +8.2 Create the Tango web application user (for token based authentication) + +CREATE USER [Tango] FROM EXTERNAL PROVIDER WITH DEFAULT_SCHEMA=[dbo] +GO + +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. -- cgit v1.3.1