Support for "Teams" for database

I am creating an app that will require support for "teams" where certain users will only have read access to certain database data. It would be cool if we could set this up directly within the database and auth for Supabase.

Appwrite has this feature, see here for more info:
[

I'm sure you can do this without this manually without this type of feature, but from my understanding, it seems like this would make it easier to do.

Hopefully I am not confused as to what this feature actually entails.