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

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

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))

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"?

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

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))

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"?

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

Similar Threads

Similar Threads

Similar Threads