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 (11)
  • 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

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

Show Empty Rows and Columns

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