Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
This isn't a feature of Supabase as yet. It's something they will add in the future but it's currently not there. And it won't be on a per role basis but on a permission basis similar to GitHub fine grained tokens.
I come from a database where roles are the primary way of managing permissions, so I just defaulted to what I know. But this "GitHub fine grained tokens." sounds amazing!
I'm really looking forward to getting my hands on this.