Make only one field editable other filed will be read only using ACL

[Sandeep Rajput · Accepted solution]

You need to define a Table.None ACL with read operation and in the role list add the role to whom you would like to provide the read access of the Table.

As a second step you need define Table.None ACL with write permission to allow users edit records within the table

As a third step you need to define a Table.Field Level Write ACLs on different columns to allow only specific role (admin) who can edit it. Make sure to not to include role of user whom you want to provide write access on a single field

In fourth step, create a Table. Field level write ACL on the single field where you would like to give access to the end user (the only field where user will have write access). Here add the end user role in the role list.

Finally when you will impersonate with your end user you should see outcome like the following when you try to edit a cell.

In the following screenshot user doesn't have access to change Group field. When he tries to change an error shows up.

In the following example User field can be updated by the end user.

Hope this helps.

[y-allen]

For me this process results in the role being able to write to all fields or no fields at all. I am a little confused at Step three, where an ACL is being added for admin on different columns? I don't understand why this is needed admin override should allow admin to write to any field, if needed, correct?

If I understand correctly, 4 ACL's will be created, correct?
read - Table.none - role
write - Table.none - no role
write - table.field(s)? - admin
write - table.field - role

[Sandeep Rajput]

@y-allen Third step is not needed, you can use write - table.field - role to allow write access to a specific field.