© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•4y ago•
4 replies
TARS

Allow CRUD for all auth users

Hello,

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 ALL
TO authenticated

WITH CHECK (true)
CREATE POLICY "Enable CRUD for authenticated users only" ON "public"."hosts"
AS PERMISSIVE FOR ALL
TO authenticated

WITH CHECK (true)


But it's not working, I can't fetch any data when I am logged in as a user.

Please point me in the right direction.
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

list all auth.users
SupabaseSSupabase / help-and-questions
4y ago
Allow select for all users that provide in input an ID.
SupabaseSSupabase / help-and-questions
8mo ago
db trigger for auth.users
SupabaseSSupabase / help-and-questions
3mo ago
Seeding auth.users for testing
SupabaseSSupabase / help-and-questions
2mo ago