© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•13mo ago•
5 replies
NAIM™

How can I allow authenticated users to access only certain columns from a table ?

Hello everyone, I need some help, as I haven't found a solution in the official documentation.

I would like to allow only authenticated users from a mobile device to access certain columns. I have two options:

Enable RLS (Row-Level Security) policy and restrict both anonymous and authenticated users from selecting data.
Enable RLS policy and restrict authenticated users to select only certain columns. But how can I achieve this?

Thank you!
Screenshot_2025-01-22_at_14.43.46.png
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

Can I only allow viewing some columns in RLS?
SupabaseSSupabase / help-and-questions
4y ago
How to disable direct access to table APIs and allow access only through RPC functions?
SupabaseSSupabase / help-and-questions
2w ago
How to retrieve a row value from a public table from all users
SupabaseSSupabase / help-and-questions
3d ago
How to query a table by multiple columns
SupabaseSSupabase / help-and-questions
4y ago