Row level security - groups & user name in the same list

Question & Answer
,
1

Hello

During the row level security, I encountered issues with the table that includes user name and group name. It doesn’t appear to be possible to have both in the same list.

Does it seem true?

I cannot find a reason why it doesn’t work for the group name.

Thanks,
Noy

1 Like
2

Hello @Noys, what isn’t working with the group name implementation? First thing I would double check is that the column is titled GroupName spelled exactly like that. It is also case sensitive so that is important. I am curious to hear about the issues you are experiencing so I can try to guide you further.

1 Like
3

Hi @DylanM !
Thanks a lot for your reply.

So the thing is that the column spelt right because it does work with user names. So I’m wondering if it’s because it couldn’t receive group names and user names together

4

Hello @Noys, have you created your groups within QuickSight and linked the users before building out the RLS file? If there are not any GroupNames in the account, I could see that throwing the error. I read through the documentation to just make sure and it says both UserName and GroupName can be used together in RLS.

1 Like
5

When you have both GroupName and UserName in a row, I believe that QuickSight uses AND logic. The user needs to have that UserName AND also be in that group. Does your user satisfy that condition?

1 Like
6

Thank you both for your reply’s!
So there is a Quicksight group which users are belong it.
Maybe it’s about it name? I just copied it exactlly the same to the row level security table and it is still not work.
image
image

1 Like
7

Hello @Noys, I see what the issue is. You need a seperate column for GroupName. It cannot be used within the UserName column since they are referencing different values in QuickSight. If you split this into 2 columns, it should work as expected.

I will mark this response as the solution, but let me know if you have any remaining questions. Thank you!