© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•3y ago•
2 replies
jdbohrman

Having two seperate `public` users table definitions?

Hey there! So my platform essentially has two different sides to it, there's the organization members who are paying to use the platform, and then the clients they invite to join their portal. So I'm exploring a switchup to my data model that would essentially haveto seperate tables in the
public
public
schema, and I'm recalling what I was told about keeping references from
public
public
>
auth.users
auth.users
. So my question is, does this apply even if you have two seperate segments of users? for example, if I have a
public.users
public.users
table and a
public.clients
public.clients
table that both references the
auth.users
auth.users
table, would I just use RLS to split those things up?
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

Cannot create public.users
SupabaseSSupabase / help-and-questions
3y ago
relation "public.users" does not exist
SupabaseSSupabase / help-and-questions
3y ago
How to retrieve a row value from a public table from all users
SupabaseSSupabase / help-and-questions
3d ago
permission denied for table users
SupabaseSSupabase / help-and-questions
3mo ago