Presented with a prompt to link account using password when pre-existing account does not use password auth method

Preflight checklist

• I could not find a solution in the existing issues, docs, nor discussions.
• I agree to follow this project's Code of Conduct.
• I have read and am following this repository's Contribution Guidelines.
• I have joined the Ory Community Slack.
• I am signed up to the Ory Security Patch Newsletter.

Ory Network Project

https://interesting-mcnulty-i7fnu6z46n.projects.oryapis.com

Describe the bug

When trying to sign-in with SSO, I am presented with a prompt to link my account using a password even though my pre-existing account does not use the password auth method

Steps to reproduce:

1. Setup Enterprise SSO connection and via self-service registration, create an account that is managed by the SSO organisation.
2. Remove the Google OIDC connection for my Enterprise SSO organisation
3. On the same organisation, setup a new Google OIDC connection
4. The OIDC connection now has a different redirect URI
5. Try to sign in with SSO
6. Run into this prompt asking me to link my account by providing a password
7. Can't provide a password because my account has no password auth method (only the outdated OIDC auth method)
8. Therefore, can't link account and so can't login using the new OIDC connection
   

Reproducing the bug

Follow steps described in the previous section

Relevant log output

No response

Relevant configuration

No response

Version

Ory Network

On which operating system are you observing this issue?

macOS

In which environment are you deploying?

Ory Network

Additional Context

No response

Start by reproducing the six-step SSO and Google OIDC connection replacement flow described in the issue, including an account with only the outdated OIDC auth method. Trace the account-linking prompt and determine how it handles accounts without password authentication; done means the new OIDC connection can be used without requiring an unavailable password.