I have a database consisting of a main table and users table, where access rules dictate what columns a user can see based on their role.
For some columns, access needs to be restricted based on user role AND whether the current user is assigned to that row.
For this restricted column, my access rule looks like
'Role 1' == user.Attributes.Role and rec.Assignee == user.Attributes.Name R U
This rule successfully prevents users whose role isn’t ‘Role 1’ from seeing the column, but it does not allow a user who meets both conditions to read or update the column - instead, the column is displayed but contains ‘CENSORED’ for every entry, including rows where the current user is the assignee.
How can this be fixed so that Mike can read and update ‘Restricted Column’ for Task 1 ?
Link to reproducing example: