List collector variable not displaying records

[booher04]

I have a custom table with 40 records created specifically to use on a list collector variable for a catalog item.  The users can see the table and records by going to it, they can also see the records if I use a lookup select box.  If I set it up with the list collector variable and go to the portal to submit the catalog item, the variable shows "no records".  If I go to the catalog item as an admin I can see the records on the list collector variable.  I have provided read access to the table and the fields on the table with the snc_internal role(as I want it to be readable by anyone and SNOW defaults to this with no other role added).  There is no reference qualifier on the variable either.  I am out of ideas. Any input would be greatly appreciated.

[Brian Lancaster]

Have you tried debugging your ACLs? Do all users have the snc_internal role?

[Bhavesh Bijagar]

Hi @booher04,

Looks like ACL issue. Please run ACL debugger to check ACLs as suggested by Brian

Just for your understanding the ACL evaluation process

[Ankur Bawiskar]

@booher04 

definitely it's an access issue.

Did you use access analyzer and see what's blocking for that user (non-admin)?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Brian Lancaster]

Thanks @Ankur Bawiskar this helped me on something I was working on. Debug security wasn't helping and causing performance issues for me anyway since it was in dev environment.