In my app I have a user profile table with a column that determines a user’s edit rights/roles.
The object to be edited has no column that can be used to create a relation, e.g. an Event with Name, Date, Description. I want the edit option to be available if the signed-in user has CanEdit = TRUE (defined in the UserProfile table)
I get the sense this should be simple to implement. What am I missing?
Also, is there a way to express nested conditions, can edit if ConditionA OR (ConditionB AND ConditionC)?