Using joins to create a data model with row-level security
There are several ways to implement row-level security in our Tableau data model. We will be looking at these in detail in Chapter 11. For the purposes of this chapter, it is worth noting that one method is to have a separate table with usernames in it joined to the data table at the row level based on the user who is signed into Tableau Server or Cloud. We bring it up here as a use case for joins versus relationships. This technique only works with joins – your data would not be secure if you used a relationship, as this could be used to generate a query from the data table without joining to check entitlements to the data.
We will look at custom SQL in the next and final section of this chapter.
