Hi All,
I have implemented row level security in universe. I have 4 regions and codes for that region.

I have to implement this for 100 users. I have created restrictions in UDT with below conditions.
SOURCE.TABLE_1.ID = 1 for Latin America
SOURCE.TABLE_1.ID = 2 for South Asia
SOURCE.TABLE_1.ID = 3 Europe
SOURCE.TABLE_1.ID = 4 USCAN
These conditions are working fine for individual user. As we can't assign multiple restrictions to one SSO, I have created User groups and added users to these groups. I have apply restrictions to these groups.
Group 1: Latin America Group 2: South Asia Group 3: Europe Group 4: USCAN
I exported changes. But it is giving AND condition in query as restriction is based on TABLE_1.ID only.
eg. if my empid is added into one group, it is giving me data but if empid has been added into more than 1 group it is giving below query which is not giving any data
AND ( SOURCE.TABLE_1.ID = 2 )
AND ( SOURCE.TABLE_1.ID = 3 )
For multiple user how row level security can be implemented? Can somebody please help me on this please?
Thanks,
Bhagya