Forum Discussion
Dynamic row level security
Hi guys, When designing my model i believed my use case would be very simple, quite the opposite. The following picture is a representation of my model: It has 1 fact table surrounded by 13 ...
Hi Anonymous ,
Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.
Best regards
Amy
Hey,
Thanks for trying but that didn't work for me. My use case is rather annoying as I don't only need to filter my fact table, I need to filter EVERY dimension because they all have rather sensitive information.
As of today I have two bad solutions which are adding a bridge + security table onto each dimension that needs to be filtered in addition to my fact.
Create a view that combines my fact tables with my security table.