Cell Edit Mode - 'Security prevents writing to this field'

[rushputin]

I'm having an issue where a non-admin user cannot edit a field in cell-edit mode.   They can edit it okay from the record, but not the list.   On double-clicking on the cell, or clicking on the cell and hitting Enter, it just hangs.   Selecting multiple cells and doing the same produces the 'Security prevents writing to this field' message.

It's clearly due to security (because the admin can edit it just fine)... but the ACLs look correct (they were generated when the table was created, and grant create, delete, write, list_edit, and add_to_list to a role the user has).   Similarly, the List Control gives that same role Edit and Link permissions and is set to List edit type: 'Save Immediately (cell edit mode)'.

The only possible complicating factor is that this is on a many to many table, but I can't see how that could be responsible.

So: what security setting am I missing?

[andrew_venables]

Hi Richard,

Have you checked the ACLs on the many to many table itself? To edit the many to many records the user will need privileges to edit this table.

Andy

[rushputin]

Yeah; when I enumerated the ACLs above, the M2M table is what I was talking about.

It's weird, because the non-admin user can do all of those things: add a relationship, remove a relationship, go into a record and edit particulars about a relationship... just cannot edit those particulars about a relationship from the list.

[ajlabate]

Was this ever answered?   I have the same situation that I'd like to get resolved.   It would be very useful for my teams that have many incidents in their queue and they could assign several to themselves at a time by updating the assigned to field.

[User140988]

It could be due to a list_edit ACL, on this table or on parent. Please use the debug security option, it will clearly give the details of which ACL is blocking it.