I have a model driven app where I need to use row level security to lock down the permissions.
A user (A) will create a record in the form (owner) and they should have access. The user will also name 2 other users via a lookup on the form in custom fields (B and C)
Is it possible to set permissions so that all users named on the record will have access to the row? (A, B and C)
Note that A could create another row and instead name users B and D and E so for this row only A, B, D and E should have permissions)
Any help would be appreciated on this.