vOriginal post
Web Developer
If I have a relation with multiple users, how can I ensure that only those users have the necessary permissions? Additionally, how can I update permissions automatically when a user is removed from the relation?
To paint a picture, something similar could be achieved within pocketbase permissions by adding a rule that looks something like "some_table.related_users.id ?= @request.auth.id". I don't expect it to be quite as easy, just looking for an efficient clean solution.
Summary
Developers are discussing user permissions and how to ensure only specific users have necessary access. The solution suggested is maintaining a table for permissions, implementing checks based on this table, and using database triggers to automate updates. This approach ensures permissions are accurate and updated when users are removed. Additionally, they are exploring ways to achieve similar functionalities as seen in Pocketbase permissions for efficient and clean solutions.