What Supabase permission level is required to use "supabase link"?

I get the errors shown below when trying to link a remote project via the CLI in any version higher that 2.31.X. I found this GH issue which talks about the first (status 403) error though the OP is the owner of the project whereas I'm merely a developer hence the post's title.

What's weird is that I only get these errors when using versions higher than 2.31.0 of the CLI. There is a second error about no

cli_login_postgres

cli_login_postgres

cli_login_postgres

cli_login_postgres role existing which doesn't make sense to me as I checked the hosted instance and there is a role called

cli_login_postgres

cli_login_postgres

cli_login_postgres

cli_login_postgres listed there. Maybe it's a result of the first one?

Full error:

$ npx supabase@latest link --project-ref [project_id]
Initialising login role...
unexpected unban status 403: {"message":"Your account does not have the necessary privileges to access this endpoint. For more details, refer to our documentation https://supabase.com/docs/guides/platform/access-control"}
failed to connect as temp role: failed to connect to `host=aws-1-eu-west-2.pooler.supabase.com user=cli_login_postgres.[project_id] database=postgres`: server error (FATAL: Authentication error, reason: "There is no user 'cli_login_postgres' in the database. Please create it or change the user in the config" (SQLSTATE XX000))

$ npx supabase@latest link --project-ref [project_id]
Initialising login role...
unexpected unban status 403: {"message":"Your account does not have the necessary privileges to access this endpoint. For more details, refer to our documentation https://supabase.com/docs/guides/platform/access-control"}
failed to connect as temp role: failed to connect to `host=aws-1-eu-west-2.pooler.supabase.com user=cli_login_postgres.[project_id] database=postgres`: server error (FATAL: Authentication error, reason: "There is no user 'cli_login_postgres' in the database. Please create it or change the user in the config" (SQLSTATE XX000))

$ npx supabase@latest link --project-ref [project_id]
Initialising login role...
unexpected unban status 403: {"message":"Your account does not have the necessary privileges to access this endpoint. For more details, refer to our documentation https://supabase.com/docs/guides/platform/access-control"}
failed to connect as temp role: failed to connect to `host=aws-1-eu-west-2.pooler.supabase.com user=cli_login_postgres.[project_id] database=postgres`: server error (FATAL: Authentication error, reason: "There is no user 'cli_login_postgres' in the database. Please create it or change the user in the config" (SQLSTATE XX000))

$ npx supabase@latest link --project-ref [project_id]
Initialising login role...
unexpected unban status 403: {"message":"Your account does not have the necessary privileges to access this endpoint. For more details, refer to our documentation https://supabase.com/docs/guides/platform/access-control"}
failed to connect as temp role: failed to connect to `host=aws-1-eu-west-2.pooler.supabase.com user=cli_login_postgres.[project_id] database=postgres`: server error (FATAL: Authentication error, reason: "There is no user 'cli_login_postgres' in the database. Please create it or change the user in the config" (SQLSTATE XX000))

GitHub

CLI link command fails with "necessary privileges" error for Projec...

Hello Supabase Team, I'm encountering a persistent "privileges" error when trying to run npx supabase link for my project, even though I am the confirmed Owner of the project. Describ...

What Supabase permission level is required to use "supabase link"?

Similar Threads

Similar Threads

Similar Threads