I have implemented row level security by using security table that joins with the fact table. It’s working as expected with filter condition.
But there is one more corporate group, these people don’t required row level security.
Is there any way we can use same universe for all groups(Corporate and row level security group) by using security profiles in IDT?
Please advise me any ideas
I created a table with my all access users. Then created a view to union my security table with my list of users who had all access so that all security was in one view.
You could try using an overide to replace the security table for your all access group.
thanks for your reply. Both are in different domains. I need to see the options to create all users in single table.