Grant access to normal users (snc_internal) to table for record producer list collector choices

[Tadz]

Hi,

Can we grant access to normal users (snc_internal) to table for record producer list collector choices upon opening form.

Scenario:

We have a list collector variable called "type" in our record producer which is referencing to sn_grc_choice table which requires sn_grc.read role for read.

Issue is when user doesn't have sn_grc.read role then they can't see the options.

And we can't always grant sn_grc.read role to every user who wants to submit the form.

Would like to hear your suggestions on how to achieve this.

Thanks,

Tads

[Ravi Chandra_K]

Hello @Tadz 

Greetings!

Please hit the thumb and Mark as correct based on Impact!!

If there are no security concerns, add snc_internal role to existing ACL. 

Kind Regards,

Ravi Chandra

[Tadz]

Hi Ravi,

Thanks for your response. Yeah, actually they want to access without configuring the ACL.

We found a workaround. We will just be using sys_choice table instead.