Dynamic RLS for Team Level Access

[chiu2003]

Hi all,

I got a request to allow user not only to view own data, but also their belonging team data.

Attachment is my mock up data model and I had setup a dynamic security role, however, I must use the bidirectional realtionship to fulfill this request.

1. Apply role to Team_Profile, then bidirectional filter to Team_Manager table
2. Team_Manger table to filter the account profile

Although it is working, any recommendation to avoid that bidirectional relationship and static role?

cos, I got so many team and user in the real model. It is hard to setup static role

Thanks a lot!

Dynamic RLS for Team Level 

[amitchandak]

@chiu2003 , You can make join single directional. You will not be able to select the bi-directional security option, but RLS should work

[chiu2003]

I try below setting, but the RLS does not work anymore as the filter director is not correct.

May I know any setting I can try?