Dynamic security uses additional information to filter the data to allow more flexibility than row-level security. In this recipe, you will create a security table that has two users, Bob and John. Then, by implementing dynamic security, the data that each is able to see will be shown.
Open the Crash_Data_Model in Visual Studio to bring up Model.bim. Then change your view to the Diagram view to see the table relationships. In this recipe, you will create a new security table and then implement dynamic security for these users by using the USERNAME() function. The USERNAME() function will return the DOMAIN\User from the account accessing the model.