Comment by thruflo
2 years ago
Yup, this is what's addressed by write permissions. You can express who can set salaries and column level rules to validate input values.
When it comes to concurrency problems like not spending money twice, the plan is https://electric-sql.com/blog/2022/05/03/introducing-rich-cr...
Row-level permissions also very useful - e.g. I am allowed to update my own profile, but not someone else's.