© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•14mo ago•
1 reply
Sam Whitmore

Creating Organisations with User Permissions with Supabase (Auth)

For context, I'm building with Svelte 5 and Supabase.

I have it set up such that an individual can create an account and then fill in a survey, storing that data in a
responses
responses
table on Supabase. They can then view their data on my website's various pages.

Beyond that, however, one of the core functions of my application is for various organisations to ask questions of their own. With this in mind, some of my users will have admin/editor/moderator/contributor permissions for one or more organisations.

I want to know how I ought to structure this.

I presume I create an
organisations
organisations
table and then have columns for each of these permission levels, or a single
team
team
column that contains a JSON object. Is this correct, or is there a better way to achieve this?

Thanks!
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

(Third Party Auth) Syncing Supabase users/organisations/entitlements with WorkOS
SupabaseSSupabase / help-and-questions
5mo ago
get user function supabase.auth.user()
SupabaseSSupabase / help-and-questions
4y ago
Struggling with supabase auth authentication loop.
SupabaseSSupabase / help-and-questions
4mo ago
Google Authentication paired with Supabase Auth
SupabaseSSupabase / help-and-questions
8mo ago