I’m having trouble selecting a dataset in the ‘Set up row level security’ → ‘Create rules dataset’ section. I want to use the same dataset that I’m setting up row-level security for, and I’m the owner of it. Am I missing a step, or is there something I need to configure first to make it selectable?
Hi @Li_Yang ,
So to create a RLS for your dataset, you will need to create another document (like an excel doc) and in that, you will put into columns the users/groups you want to apply RLS to and in another column, you will add the rule or rules. I would refer to this resource for more details in terms of an AWS resource perspective (Using row-level security with user-based rules to restrict access to a dataset - Amazon Quick Suite). Moreover, there is also an old community post that includes a video that helps visually break down the steps. It is a bit of an older video but I believe the contents are still just as relevant. Here is the post (Applying row-level security to the parent dataset - Q&A - Amazon Quick Suite Community).
Let me know if this helps!
@JacobR Thanks for the quick response! I uploaded the user list and granted myself permission to view all records. However, after applying the rule, I’m unable to view any records. Could you please provide some guidance on what might be going wrong?
Hi @Li_Yang
QuickSight row level security is sensitive when it comes to the column names. I see you have named your column as username. Please change it as UserName.
Secondly, leave site_code column value for your row as blank and it will give you access to all rows of data.
Regards,
Giri
1 Like
HI @Giridhar.Prabhu ,Thank you so much! It works!