Tag: Security

  • Row-Level Security with Initial SQL

    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!