End user is not able to see the users on record producer form

[sunil maddheshi]

Hi Everyone good morning,

I have a variable set ''Requestor's details" under it i have a reference field "Requested for" reference to user table(sys_user) with simple reference qualifier. My issues is as an admin i can see the users in requested for but as an end user i can not see any users in that. I have attached the screenshot. Please help

[Ankur Bawiskar]

@sunil maddheshi 

check the end user has valid role to see the table data i.e. table level READ ACL should evaluate to true then only users will be seen

Are you sure you verified this?

[sunil maddheshi]

Hi Ankur, I checked the ACL on user table , there was a  read ACL with role public , I have granted that role to End user still he can not see the users. attaching screenshot of acl

[Ankur Bawiskar]

@sunil maddheshi 

the table level READ ACL script will allow only that user which matches the logged in users name

i.e. if you login then it will show only 1 user which is your record

Please check this

Also check any Query BR on sys_user is restricting records to end users