How to open a custom table for everyone to view/edit

[booher04]

I have created a custom table for a lookup select box field on a Catalog Item form.  The form/field work fine for me and work as intended, however when a normal user goes to the form and tries to select a user from the field it's blank and says none.  I know this is due to permissions on the table itself, but I need to get it set so that anyone can select from that field on the form. The table is u_macd_approvers and the field is it_director.

[Mike Patel · Accepted solution]

Create Read ACL for your custom table and don't add any role so everyone can see the record in drop down.

[Nithish1]

Hello,

Remove roles under create and read ACL's for the custom table.

Thanks,

Nithish

[Nithish1]

I hope you got your answer.

Please do mark my answer correct so other users can find it more easily (and to serve me up a delicious helping of community points :D)

[SanjivMeher]

It should have created 4 ACLs automatically. You need to open the Read ACL and remove any role exists in that ACL.

If you want user to be able to write, open the write ACL and remove any role exists.

If none of the ACLs exists, you need to create them manually.