Blog

15
JUL
2019

Row-Level Security with Initial SQL

Tags : Azure, RLS, Security
Kommentare : 1
How to replicate this in your own environment?

  • Create a free test account on Microsoft Azure
  • Create a SQL Database on Azure
  • Install Microsoft SQL Server Management Studio
  • Follow the instructions on Manoj’s great blog post to:
  • Create 3 users on the database
  • Create a new table
  • Fill the table with content

How to replicate this in your own environment?

  1. Create a free test account on Microsoft Azure
  2. Create a SQL Database on Azure
  3. Install Microsoft SQL Server Management Studio
  4. Follow the instructions on Manoj’s great blog post to:
    1. Create 3 users on the database
    2. Create a new table
    3. Fill the table with content
    4. Setup row-level security on the content
  5. Create the 3 users of step 4.1 on your Tableau Server
  6. Open Tableau Desktop and connect as one of these 3 users to the table you’ve been creating
  7. Create an initial SQL statement like this 
    EXECUTE AS USER = [TableauServerUser] WITH NO REVERT;
  8. Publish the data source – DONE! 😉

 

@Manoj: Thank you very much for your blog post around how to setup Row-Level Security on Microsoft SQL Server! You made it very easy to understand the process of setting it up!

Timo Tautenhahn
Über den Autor
Timo originally coded his own BI-application by making use of different JAVA libraries. He Worked for IBM as BI-specialist and BA-architect before he joined Tableau. Favorite subject: JavaScript API

Teilen

  • google-share

Ein Kommentar

  1. Avatar
    Manoj Pandey 30. June 2020 at 7:34 Reply

    Thanks Timo for your kind words 🙂

Kommentare Cancel reply

*

*

captcha *

Categories

  • Admin Area (1)
  • Data Stories (1)
  • Developer (2)
  • Embedding API (2)
  • Extension API (12)
  • Geek Stuff (3)
  • Hacks (1)
  • Ideas (8)
  • Industry Related (1)
  • Neuigkeiten (6)
  • News (3)
  • Performance (2)
  • Salesforce (1)
  • SAP (1)
  • Success Stories (1)
  • Tableau 10 (1)
  • Tableau 9 (1)
  • Tableau Server (3)
  • Tableau Visualization Extensions (1)
  • Tipps & Tricks (10)
  • Tips & Tricks (1)
  • Tutorials (14)
  • Visual Inspiration (8)

Tags

artilize Azure bericht Cloud Cloud Database conference Datalake dynamisch embed Embedding Extension API Extract API html javascript api kpi mobile munich news on-demand on-tour parameter RLS Salesforce SAP SAP BW Security Snowflake SSO tc Write Back

Last posts

Tableau Extensibility Framework - More Use Cases

Tuesday, 21. March 2023
Timo Tautenhahn - Tableaufans.com - Tableau Visualization Extensions - Create and share your own chart types - Live Devs on Stage TC21

Tableau Visualization Extensions

Thursday, 11. November 2021

How to configure Tableau Online Single Sign-On with Salesforce as Identity Provider?

Monday, 16. November 2020

Tableau Extensibility Framework

Thursday, 17. September 2020

Embedding Tableau Responsively

Tuesday, 26. May 2020
  • Blog
  • About
  • Contact
  • Legal
© 2019 - tableaufans.com - All rights reserved
Concept and design: www.emodia.de