Skip to Content
0
Dec 21, 2022 at 09:39 AM

Row Level Security in UDT

133 Views

Hi All,

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

image.png

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

Attachments

image.png (2.6 kB)