User Specific Update, Add, Delete expression

[rocketdigital]

I have a "Users" table and an "Inventory" table. I want the users to be able to see the entire "Inventory Details", but I want them to only be able to Update, Add and Delete inventory items connected to their USEREMAIL(). What would the best expression be?

[dbaum]

In this case, don't Control add, update, and delete operations at the table level. Rather, use each action's Only if this condition is true property to suppress actions for rows not "connected to their USEREMAIL()".