Access Issue: User Without Roles Cannot Read Custom Table Data

[Erica2]

I created a List Collector variable to retrieve records from a custom table, applied read ACLs at the record level, and assigned the public role. Why are users without any roles—and even those with the ITIL role—still able to see the data?

Any suggestions or insights would be greatly appreciated.

Thank you

[Ankur Bawiskar]

@Erica2 

you have given public role so itil user is also able to see that.

Don't give public role.

When you created that custom table a role must have been created along with that.

Add that role in roles section for that ACL

then itil user won't be able to see the data

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

[Erica2]

@Ankur Bawiskar 

Thank you for your help. I’d like to clarify the issue further.

The List Collector variable is currently being used in a Service Request (via the Service Portal).

I want both users without any roles and users with the ITIL role to be able to select values from this variable. However, the data is not displaying, even for users with the ITIL role.

Interestingly, when I use the same table in a Lookup Select Box variable, it works as expected the data loads correctly.

[Ankur Bawiskar]

@Erica2 

list collector will allow multiple selection.

If you want users without roles and itil to select then it's already working fine right as itil user is able to see the data.

But now you are saying for itil data is not seen?

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

[Erica2]

@Ankur Bawiskar 

The issue we're facing is that users without any roles, as well as users with the ITIL role, cannot see the data. We need assistance resolving this.

[Ankur Bawiskar]

@Erica2 

add public and itil role in the roles section in Table.None READ ACL

Is there any query business rule on that table which is restricting?

Also in the variable permission tab add public and itil role

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