© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•13mo ago•
12 replies
Andrew

Question About Safely Modifying the auth.users Table in Supabase

Hi everyone,

I have a question regarding the auth.users table in Supabase. I’m considering adding a new column, has_access, to this table. The idea is to use this column to check during login whether a user is allowed to access the site or not.

Before proceeding, I want to ensure that this approach is safe. Specifically:
1. Could adding a custom column to the auth.users table disrupt its internal structure or functionality?
2. Are there any potential risks or best practices I should be aware of when modifying this system table?

I’d appreciate any advice or insights from those who have worked with Supabase or similar systems. Thanks in advance!
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

Deleted the auth.users table
SupabaseSSupabase / help-and-questions
4y ago
Question about supabase oauth in mobile.
SupabaseSSupabase / help-and-questions
4y ago
Supabase Auth: why set supabaseResponse in setAll() again?
SupabaseSSupabase / help-and-questions
3mo ago
Safely upgrade supabase compute
SupabaseSSupabase / help-and-questions
4mo ago