Row Level Security in UDT

[matix10]

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

[amitrathi239 · Accepted solution]

In the manage restriction window ->Restriction options (next to the help icon) select the option " Combine row restictions using AND within group hierarchies and OR between groups" and then try.

[matix10 · Accepted solution]

Hi amit.kumar71,

Thank you so much for your great help!

I have a small concern. We need to ensure that script should not be updated by any user for this row level security. So just want to check if we can disable the "Use custom query script" in query script viewer panel in webi?

Thanks,

Bhagya