How to Apply RLS so Each User Sees Only Their Own Company Data (Based on Excel Mapping)

Q&A
,
1

Hello Team,

I need help applying Row-Level Security (RLS) in Amazon Quick Sight based on a mapping Excel file where each user should only see data related to their own company.

I have an Excel file with the following structure:

Company Names UserName
IOC Middle East FZE rahulmehta
IndianOil priyasharma
Lanka IOC PLC arjunkumar
IndOil Global snehareddy
IOC Sweden AB vikramnair
IOCL (USA) Inc anitapatel
IOCL Singapore Pte Ltd pradeepkumar

I want RLS to filter this main dataset so that each user only sees their own company’s rows, using your Excel mapping file:

Main dataset which contains columns like
Company Names, Region, Pin code, value, …other columns

2

Hi @bpradeepkumar

To ensure each user views only their company’s data in dashboards, please try implementing Row-Level Security (RLS) using your excel mapping file. This setup filters the main dataset (with columns like Company Names, Region, Pin code, value, etc.) so users such as “rahulmehta” see solely “IOC Middle East FZE” rows, “priyasharma” sees “IndianOil”, and so forth.

Prepare the excel permissions file with a structure of two columns: UserName (Quick username e.g., rahulmehta) and Company Names (e.g., IOC Middle East FZE). Upload the permissions dataset into Quick and then apply RLS to the main dataset using the permissions dataset.

3

Hi @bpradeepkumar

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

4

Hi @bpradeepkumar

Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!

5

Hi @Xclipse,
Thanks for your Response we have implemented the approach.