URGENT: All `auth.*` tables have RLS enabled, blocking tenant login (500 Error)
auth
Help! My project's entire
auth
auth
schema has Row Level Security enabled on ALL 16 tables (
auth.users
auth.users
,
auth.sessions
auth.sessions
, etc.), which is blocking tenant authentication. Symptoms: - Tenant login fails with
500 Internal Server Error: Database error querying schema
500 Internal Server Error: Database error querying schema
- Auth Hook is NOT called (error happens earlier in the internal auth flow) - Platform Owner login works fine (likely due to different session handling or cached permissions) Diagnostics: I ran this query: ```sql SELECT tablename, rowsecurity FROM pg_tables WHERE schemaname = 'auth'; Result: All 16 tables return rowsecurity = true.
Attempted Fix: I tried disabling it via SQL Editor:
sql ALTER TABLE auth.users DISABLE ROW LEVEL SECURITY; Result: ERROR: 42501: must be owner of table users
Project Context:
Project ID: qatcwqxlruytzdisfxns Support Ticket: #SU-324701 (Simples/Free support) Question: Is there ANY way to disable RLS on auth tables without waiting 48h+ for support? Or a workaround to get tenant login working immediately? This is a critical production issue.
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.