Row Level Security using Two Tables

[mohit_K]

I have a Data Table as shown below :-

Territory ID	Value	SKU ID
1	11	22
1	22	23
1	33	22
2	44	23
2	55	22
2	66	23
3	77	24
3	88	24
3	99	22
4	12	25
4	13	26
5	14	25
6	32	24
6	54	24
6	45	27
6	67	27

I have two other tables, one for Territory ID mapping and the other for SKU ID mapping.
As shown below :-
Territory Table :-

Territory ID	Email Id
1	A@gmail.com
2	A@gmail.com
3	d@gmail.com
4	bb@gmail.com
5	cc@gmail.com
6	cc@gmail.com
7	A@gmail.com
8	k@gmail.com
1	c@gmail.com
1	dd@gmail.com
2	dd@gmail.com
3	dd@gmail.com
4	dd@gmail.com

SKU Table :-

SKU ID	Email
22	mk@gmail.com
23	A@gmail.com
24	m@gmail.com
25	b@gmail.com
26	mk@gmail.com
27	A@gmail.com
22	A@gmail.com
23	mk@gmail.com
25	mk@gmail.com

The Territory and SKU tables are linked to Data Table with a Many to Many Relationship
I want to apply Row Level Security such that the rows in the Data Table are filtered
according to the user logged in and they should be able to view only the Territory or SKU assigned to them.

So if user dd@gmail.com logs in them the Output should be :-

Territory ID	Value	SKU ID
1	11	22
1	22	23
1	33	22
2	44	23
2	55	22
2	66	23
3	77	24
3	88	24
3	99	22
4	12	25
4	13	26

dd@gmail.com only exists in Territory Table hence only filter from that table

if user mk@gmail.com logs in them the Output should be :-

Territory ID	Value	SKU ID
1	11	22
1	22	23
1	33	22
2	44	23
2	55	22
2	66	23
3	99	22
4	12	25
4	13	26
5	14	25

mk@gmail.com only exists in SKU Table hence only filter from that table

if user A@gmail.com logs in, then the Output should be :-

Territory ID	Value	SKU ID
1	11	22
1	22	23
1	33	22
2	44	23
2	55	22
2	66	23

A@gmail.com exists in both Territory and SKU Table hence filter from both the tables.

How should I go about creating Row Level Secutrity on these two independent tables?

[Anonymous]

Hi @mohit_K,

Did this suggestion help with your scenario? if that is the case, you can consider Kudo or accept it to help others who faced similar issues.

If these also not help, please share more detailed information to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[Anonymous]

HI @mohit_K,

Perhaps you can write two search expressions to lookup values from different tables to get 'SKU id' and 'Territory id' based on USERNAME function.
Then you can use filter both two fields with 'OR' logic on the 'mapping' table at the same time. 

Regards,

Xiaoxin Sheng