Does anyone have any RBAC/CBAC best practices?
I really want to keep our model as close to Supabase/Postgres as possible, I'd prefer the user role(s) to be attributed in the auth table (so I can add policies without referencing the JWT or additional tables), but that doesn't seem possible.
I've tried setting up Postgres roles with inheritance but that command "inherit" doesnt actually work and it will limit the user to a single role.
I've tried setting up Postgres roles with inheritance but that command "inherit" doesnt actually work and it will limit the user to a single role.
