SupabaseS
Supabase•3mo ago
xananax

Supabase link giving me permission denied

npx supabase link gives me:

Selected project: <project id>
WARN: no SMS provider is enabled. Disabling phone login
Initialising login role...
Connecting to remote database...
failed to fetch storage migration: ERROR: permission denied for table migrations (SQLSTATE 42501)
Finished supabase link.


I am not sure what to do.

This issue (https://github.com/supabase/supabase/issues/21615) and this related one (https://github.com/supabase/supabase/issues/10982) says to:


  1. Your project has been upgraded to the latest version (check here)
  2. You are using the latest Supabase CLI
  3. Your 
    postgres
     user has the supabase_functions_admin privilege
I am unable to do (1) for the moment (I cannot afford to interrupt my website). (2) is true, I am using the latest CLI. And I don't think (3) is relevant? Isn't the 
postgres
 user having full privileges?

At any rate it doesn't look like the role exists anymore
Was this page helpful?