From 56d70f95c576cfac02b4a24e7373039a183d197b Mon Sep 17 00:00:00 2001
From: Roy <Roy.mail.net@gmail.com>
Date: Sun, 24 Jul 2022 15:46:45 +0300
Subject: Added notes for Tabeau DB login.

---
 Software/Visual_Studio/Notes/Tango.Notes/Azure/Tableau.txt  | 6 ++++++
 Software/Visual_Studio/Notes/Tango.Notes/Tango.Notes.csproj | 3 ++-
 2 files changed, 8 insertions(+), 1 deletion(-)
 create mode 100644 Software/Visual_Studio/Notes/Tango.Notes/Azure/Tableau.txt

(limited to 'Software/Visual_Studio/Notes/Tango.Notes')

diff --git a/Software/Visual_Studio/Notes/Tango.Notes/Azure/Tableau.txt b/Software/Visual_Studio/Notes/Tango.Notes/Azure/Tableau.txt
new file mode 100644
index 000000000..c910d57a4
--- /dev/null
+++ b/Software/Visual_Studio/Notes/Tango.Notes/Azure/Tableau.txt
@@ -0,0 +1,6 @@
+On master:
+CREATE LOGIN Tableau WITH PASSWORD = 'Twine2022!@#$';
+
+On catalog e.g "Tango_DEV"
+CREATE USER Tableau FOR LOGIN Tableau;
+ALTER ROLE db_datareader ADD MEMBER Tableau;
\ No newline at end of file
diff --git a/Software/Visual_Studio/Notes/Tango.Notes/Tango.Notes.csproj b/Software/Visual_Studio/Notes/Tango.Notes/Tango.Notes.csproj
index 6491cfa8e..f7cf513c6 100644
--- a/Software/Visual_Studio/Notes/Tango.Notes/Tango.Notes.csproj
+++ b/Software/Visual_Studio/Notes/Tango.Notes/Tango.Notes.csproj
@@ -46,6 +46,7 @@
     <Content Include="Advanced Installer\License.txt" />
     <Content Include="Azure\Publish Tag Creation PAT.txt" />
     <Content Include="Azure\New Environment.txt" />
+    <Content Include="Azure\Tableau.txt" />
     <Content Include="Azure\Test User Credentials.txt" />
     <Content Include="Azure\SQL Database.txt" />
     <Content Include="DB\DB Schema Change Log.txt" />
@@ -69,7 +70,7 @@
   <Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" />
   <ProjectExtensions>
     <VisualStudio>
-      <UserProperties BuildVersion_StartDate="2000/1/1" BuildVersion_UseGlobalSettings="False" BuildVersion_BuildVersioningStyle="None.None.Increment.TimeStamp" BuildVersion_UpdateAssemblyVersion="True" BuildVersion_AssemblyInfoFilename="Properties\AssemblyInfo.cs" />
+      <UserProperties BuildVersion_AssemblyInfoFilename="Properties\AssemblyInfo.cs" BuildVersion_UpdateAssemblyVersion="True" BuildVersion_BuildVersioningStyle="None.None.Increment.TimeStamp" BuildVersion_UseGlobalSettings="False" BuildVersion_StartDate="2000/1/1" />
     </VisualStudio>
   </ProjectExtensions>
 </Project>
\ No newline at end of file
-- 
cgit v1.3.1