© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•4y ago•
1 reply
turner

Postgres RLS user

I created a postgres user, but still I cannot add privileges to
rls_user
rls_user
(neither from the SQL Editor in the dashboard) to read from my tables. the user can connect to the database, but a
select * from table_name
select * from table_name
returns an empty array.
is there any documentation on how to properly add a user to the supabase postgres db? has anyone had the same issue?

I want a user to connect directly to the database instead of using supabase‘s postgRESR API. The user should be affected by RLS, I want to set the jwt claims at every session.
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

Postgres User
SupabaseSSupabase / help-and-questions
14mo ago
RLS auth each user
SupabaseSSupabase / help-and-questions
4y ago
DELETE user_role RLS fails silently instead of returning RLS error to user
SupabaseSSupabase / help-and-questions
4y ago
Create a user account with RLS
SupabaseSSupabase / help-and-questions
4y ago