Row-Level Security with Initial SQL

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!

Comments

One response to “Row-Level Security with Initial SQL”

  1. Manoj Pandey Avatar

    Thanks Timo for your kind words 🙂

Leave a Reply

Your email address will not be published. Required fields are marked *