{"id":2873,"date":"2021-01-19T01:00:00","date_gmt":"2021-01-19T01:00:00","guid":{"rendered":"https:\/\/www.biconnector.com\/blog\/?p=2873"},"modified":"2021-09-26T13:26:24","modified_gmt":"2021-09-26T13:26:24","slug":"how-to-set-up-row-level-security-rls-in-tableau","status":"publish","type":"post","link":"https:\/\/www.biconnector.com\/blog\/how-to-set-up-row-level-security-rls-in-tableau\/","title":{"rendered":"How to Setup Row Level Security (RLS) in Tableau?"},"content":{"rendered":"\n
When setting up reporting of any kind with your company\u2019s often sensitive data, one of the critical questions to answer is – How can we effectively secure the data?<\/p>\n\n\n\n
Row Level Security (RLS) is a hot topic in the Tableau world. While it is possible to set up in Tableau Desktop it currently requires a lot of setup and maintenance. The complexity of the RLS setup varies depending on the number of dimensions you want to secure. In this article, we\u2019ll keep it simple to help you easily learn how it works!<\/p>\n\n\n\n [Tableau Hacks] How to Improve Interactiveness With Parameter Actions? >><\/b><\/p>\n<\/div>\n<\/div><\/a>\n\n\n\n We\u2019ll just create an entitlements table that lists out each of the users by username and assign them a role. Then, we\u2019ll assign the roles to specific dimension members for restricting the data.<\/p>\n\n\n\n In an actual case, the usernames would correspond with the tableau usernames belonging to each of your licensed tableau users. For now, we\u2019ll just use the Harry Potter names to illustrate how this works.<\/p>\n\n\n\n The table must be secure enough that only the security manager and\/or their delegates have access to it. However, keep in mind that when it is updated it will need to interface with the posted tableau reports where the RLS needs to be utilized. You may use whatever file medium works for you to manage these tables (csv, google sheets, txt file, etc).<\/p>\n\n\n\n The first table, for instance, lists out all of the users by Username and assigns them a Role and Role_id. The Role column contains a description mainly for clarity purposes to make managing the user list easier. It would look something like this: <\/p>\n\n\n\n