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 gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.