Database RLS

How do I set Role Level Access at the Database level

For example I want only users on the members collection to be able to access a workspace collects

Imagine Slack a user from another workspace should not be able to access the db of another workspace, am trying to enforce some security at the db level

TL;DR

Developers are looking to enforce Role Level Access (RLS) at the database level. They want to restrict access to collections based on user roles, similar to how Slack restricts access between workspaces. One solution involves programmatically setting permissions in the "permissions" array when creating a document using the appwrite.io API. This allows developers to control access to specific collections or documents based on user roles.