Forum Discussion
Security trimming alternatives to RLS
Hello, I’ve been doing some reading around how to implement RLS for our embedded report but, so far it appears we can’t use this approach to trim data based on the user. I’m hoping someone out the...
You can add another claim to your SQL server database that links data visibility to a user role or even email address. Then in your dataset define the RLS rules for each table that controls visibility (ie ideally the highest ranking dimension table) based on that claim.
That way all users can access the same workspace/dataset, but their visible data is trimmed by RLS.