Testing the Column Filter Policies Within Studio
TDV provides the ability to test the Column Filter policy within Studio, but recommends that you perform thorough testing of your Column Filter policies by setting up a working test environment that includes all the data sources and client applications that would be interacting with the data for which you have defined Column-Based security.
To test your Column Filter policy within Studio
1. Log in as a user with row-based security (RBS) or column-based security (CBS) access rights or as the Administrative user with the Modify All Resources right.
2. Identify any existing table or view resources for which you want to test Column-Based security.
3. Assign a policy for a non-admin user to at least one column.
4. Use the test identity tab functionality to simulate identity and input non-admin@Domain to verify results.
OR
5. Restart or refresh Studio and log in as the non-admin user.
6. Open and execute the view for which the column-based security policy was applied.
7. Review the data.