© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•5w ago•
2 replies
jkwok678

secret_keys permissions

PostgRESTauth
I'm trying to access supabase from my backend
I have a sql function called
create or replace function public.updateXYZ(target_user_id uuid)
create or replace function public.updateXYZ(target_user_id uuid)


Does using the secret key give all permissions?
Or do I still need something like
grant execute on function public.updateXYZ(uuid) to secret_role;
grant execute on function public.updateXYZ(uuid) to secret_role;

Does secret role exist?
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

Python Client with new secret keys
SupabaseSSupabase / help-and-questions
2mo ago
Are service role keys (old) and secret keys (new) equivalent?
SupabaseSSupabase / help-and-questions
5mo ago
Edge functions and new secret api keys
SupabaseSSupabase / help-and-questions
3mo ago
Missing secrets for secret and publishable keys
SupabaseSSupabase / help-and-questions
3mo ago