Page 1 of 1
lookup table only works with administrator user (v2021)
Posted: Thu Mar 21, 2024 4:27 am
by Kpta
Hello,
I'm using a static security level and I came across the lookup table only working for the Administrator user. I deleted the entire project and generated it again, checked all updates and permissions, without success. It was working normally.
Any user other than the administrator, lookup table does not show the items.
Re: lookup table only works with administrator user (V2021)
Posted: Thu Mar 21, 2024 9:37 am
by mobhar
Make sure you have already given the lookup permission for your desired user level.
Re: lookup table only works with administrator user (v2021)
Posted: Thu Mar 21, 2024 8:58 pm
by Kpta
Thanks for the feedback.
I've checked everything, the permissions have been checked and they are ok.
The user has access to the table, can include, change and delete, that is, they have full access to the tables. The problem is only with the lookup table.
Re: lookup table only works with administrator user (v2021)
Posted: Fri Mar 22, 2024 12:33 am
by yinsw
Table A
Table B (Use as Lookup table in Table A)
You must assign Lookup permision for Table B, not Table A
Re: lookup table only works with administrator user (v2021)
Posted: Fri Mar 22, 2024 1:54 am
by Kpta
All permissions have been given and it still does not show the table items, there are 4 lookup table fields for different tables. It was working, then suddenly it stopped working. I have already reviewed the entire routine, permissions, parameters without success. The item linked to the lookup table appears in the preview.
Re: lookup table only works with administrator user (v2021)
Posted: Sat Mar 23, 2024 11:36 am
by mobhar
Re: lookup table only works with administrator user (v2021)
Posted: Tue Mar 26, 2024 9:18 am
by mobhar
Has your problem been resolved by using Dynamic User Level Security?
Re: lookup table only works with administrator user (v2021)
Posted: Tue Mar 26, 2024 9:59 pm
by Kpta
Yes, now I'm making some adjustments.
How can I change the table name in the permissions for routines?
How do I apply alternating row color to the permissions "table"?