Forum Discussion
Solved
Row Level Security exclusions
I don't think it's possible but I'm putting it out there. I've got a fact table that has RLS against the DEPT ID field. I was wondering if it's at all possible to exclude RLS against the particul...
Thanks everyone for the responses.
It wasn't that I didn't know how to create a solution more wondering if RLS could be ignored against a particular column in spite of it being against the nature of RLS.I'm dealing with fact tables of about 500M rows so wanted to limit duplicate aggregation tables if possible but don't think it is possible
Hi nrichards_au You could achive this thorugh DAX or BY moving the rquired to a dim table please try these
Custom RLS Filter in DAX
- Apply a filter that allows unrestricted access to rows based on Org:
[DEPT ID] = "AllowedDeptID" || [Org] = "T"
- Apply a filter that allows unrestricted access to rows based on Org:
Separate Roles for Exclusions
- Create two roles: one with RLS for restricted users and another unrestricted for users who need access to Org.
You could also remove the Org column from Fact and create a Dim table and apply rls to fact only not to Org
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance
- Create two roles: one with RLS for restricted users and another unrestricted for users who need access to Org.