Disable google sso for a user

1

How, as an admin, can I change a user's email and disassociate them from google login? I'm using a self hosted metabase 52.

I know how to change the email, but reseting password (with google enabled or disabled) does not work. It sends an email saying:

We can't reset your password because you're using single sign-on to log in to Metabase. Use the "Sign in with SSO" button on the log in page. To change your password, you'll need to contact an administrator.

Any hints on how to disassociate google sso from a user?

2

Did he perform the login with SSO or he was invited to metabase? i.e. his first login was via Google SSO?

3

I have users who did both. Some started with google and some added it.

My company was acquired and our google workspace account is going away. I need to get these people all off the google sso and on to email / password.

4

That is a bit of a problem cause we have some missing functionality around that:

Depending on the metabase version you're running you will need to go into the core_user table and make sure these users don't have the sso option enabled, for reference:

5

That worked.. we just cleared out the sso_source column in core_user, and then let the users reset their own passwords, and all is good.

Thanks!