Need to Apply RLS to Multi level managers

I am currently facing challenge with implementing RLS for Multi level managers. Background: my data have multi level managers like third level managers (senior management) → second level manager (management)-> first level manager(manager)->account managers ->accounts.
this dashboard should be accessible to all the users meaning for all level managers
need four level access like below use cases

  1. the third line manager should view all second line managers mapped to them and all the first line managers mapped to the second line managers and all the account managers mapped to the first line managers and account managers with their individual access to their accounts
  2. similarly the second line manager should view all the first line managers mapped to them and and all the account managers mapped to the first line managers and account managers with their individual access to their accounts
  3. the First line managers should access all the account managers mapped to them and account managers with their individual access to their accounts
    4)Account managers with their individual access to their accounts

Also for each account manager there are 200 -300 accounts mapped in the data. Do we need to add all the accounts in the rls mapping file ? or the user manager mapping will automatically restrict the account data?

Thanks,
Madhu

Hello Madhu,

To be frank, i am not very sure if you need to add all those accounts as i have not tried it myself.
I would recommend to try it out with some dummy data to find out if it works or not.

you may refer this post for reference -Implement row-level security using a complete LDAP hierarchical organization structure in Amazon QuickSight | AWS Big Data Blog

Hope this helps.

Cheers,
Deep

1 Like

Hi @Madhu_Latha,
It’s been awhile since we last heard from you; following up to see if you had any additional questions regarding your initial topic or if you were able to find a work around?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

Hi @Madhu_Latha,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for any relevant information that may be needed.

Thank you!