[12.0/14.0] auth_oidc: OAuth account linking

[Lanhild]

Is your feature request related to a problem?
When configuring an OIDC/OAuth provider in Odoo, I have to manually input the OAuth user's ID (sub) to the oauth_uid field on the corresponding res.users, even though the token mapping in the OAuth configuration is correct.

This happens with Keycloak, Authentik, etc.

Describe the solution you'd like
Being able to automatically link a user's OAuth account to it's corresponding account in Odoo.

Whether it is a button that allows the user to link their OAuth account, or a per-provider setting that allows automatic linking when the OAuth user's and Odoo user's emails correspond.

Describe alternatives you've considered
No viable alternative.

Additional context
Any clues? It'd be helpful if there are working examples where I don't have to set the oauth_uid myself.

Essentially, this issue's a bug as it doesn't allow proper usage of the module.

[github-actions]

There hasn't been any activity on this issue in the past 6 months, so it has been marked as stale and it will be closed automatically if no further activity occurs in the next 30 days.
If you want this issue to never become stale, please ask a PSC member to apply the "no stale" label.

[Lanhild]

Still relevant

[okawo80085]

This is still present and is very annoying on v18.0 and v19.0 (and every other version prob), since i am already fixing stuff here, gonna look into adding a "link to SSO" button for user profiles so that the user can perform this action, instead of the admin having to go through the DB by hand each time

[okawo80085]

So funny thing, this was (at least on odoo 18) a part of the oauth addon from odoo, it added an Oauth tab where you could select the provider and uid for the user, only available to admins, but better then having to manually edit the DB, not sure why they didn't add it/removed it in odoo 19, but oh well

For myself i made a version with the missing view added again, you can find it here:
https://github.com/okawo80085/server-auth/tree/tmp_oauth_user_settings

I will probably open an MR in the official Odoo repo to add it back, but while it's not merged, my fork is more than usable (and if you are on a different version, you can just cherry-pick the commit with that change in the branch for your specific version)