User level Security Issue

hsan · Post by **hsan** » Wed Apr 03, 2019 4:39 am

I am using dynamic user level security. For some fields, I have 'Use lookup table' configuration. Everything works fine with admin logged in, but for any other user, no matter how security rights are set in User Level Permissions, lookup does not work. The field shows original value, thus bypassing lookup. I tried assigning User's full right on everything for involved tables, but the field still shows just original value.

arbei · Post by **arbei** » Wed Apr 03, 2019 9:26 am

According to help file: Even you enable all permissions for an user defined User Level, the User Level will NOT become same as this Administrator User Level. If the lookup table is a protected table which can only be accessed by administrators (e.g. user table, user level table and user level permission table), other users cannot access. However, if you want to expose them to other users, you can create a view and use the view as lookup table.

hsan · Post by **hsan** » Wed Apr 03, 2019 10:46 pm

Thanks! That explains it.