I'm making an admin app where the user just needs to be authenticated to be able to access a table. And of course the only way to get a user is to be invited directly through supabase.
This is the policy I'm using:
CREATE POLICY "Enable CRUD for authenticated users only" ON "public"."hosts"AS PERMISSIVE FOR ALLTO authenticatedWITH CHECK (true)
CREATE POLICY "Enable CRUD for authenticated users only" ON "public"."hosts"AS PERMISSIVE FOR ALLTO authenticatedWITH CHECK (true)
But it's not working, I can't fetch any data when I am logged in as a user.
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.