Multi-seat orgs in Supabase

Alex

4 months ago

Hey team!

Anyone built out multi seat orgs in Supabase?

One company account with multiple users who can log in with permissions

I have it set up in Supabase with my table structure but trying to figure out my first step in toddle with the API calls to read and edit new rows etc.

Anyone building a CRM or Portal with orgs and users?
Lucas G

4 months ago

Yeah you’ll need to tie roles to each user. I do so with custom claims
This can get a bit complex pretty quickly depending on the level of access you need to set throughout your app
Alex

4 months ago

Talking with customers, probably only needing two roles

Admin and Marketing access

Essentially a full control or just editing data abilities
I’ve got roles ready, just need to use them
Armand

3 months ago

To deal with this I've set up a table that has columns for user, org and role. I just call that table on load (with Query parameters).

Not sure if its the best way to deal with this, but in my testing it works fine.
Tod

3 months ago

Great energy @Armand! Your continuous contribution to the toddle Community just made you advance to Community Level 11!