Row level security for joined datasets

Question & Answer
1

Can any one help in understanding row level security for joined datasets?

2

Hi @nitishpala - You can create a custom data set and implement the RLS on top of that , are you facing any challenges or issues on this?

Hi @David_Wong - please provide your expert advise on this?

Regards - Sanjeeb

2 Likes
3

Hi,

This will help you

If any confusion, let me know I will fix it :slight_smile:

Regards,
Naveed Ali

2 Likes
4

Hi @Naveed thanks for your support.I am able to apply row level security for single dataset.

But I want to apply row level security for joined datasets

1 Like
5

Hi,

Apply with the same methodology. This should work.

regards,
Naveed Ali

2 Likes
6

If you’re asking how row-level security works for the combined dataset when joining existing datasets that already have RLS applied to them, take a look at this:

Child datasets that are created from a parent dataset that has RLS rules active retain the same RLS rules that the parent dataset has. You can add more RLS rules to the child dataset, but you can’t remove the RLS rules that the dataset inherits from the parent dataset.

Child datasets that are created from a parent dataset that has RLS rules active can only be created with Direct Query. Child datasets that inherit the parent dataset’s RLS rules aren’t supported in SPICE.
Using row-level security (RLS) with user-based rules to restrict access to a dataset - Amazon QuickSight

2 Likes