Migrating Google Workspace user to OIDC SSO issue

[oakbrad]

I originally set up Outline with Google Workspace SSO, and the initial account I created was linked to that Google Workspace. The rest of my users are not on this workspace.

I have set up Discord SSO via OIDC, and it appears to be working for every account I've tested except my own, which is the only account associated with the Google Workspace. I get an "unauthorized - you do not have permission to view this workspace." error when signing in with Discord (although magic links still work as expected).

I looked around in the database a little bit, and I can see in my authentication_provider table the providerId for google is the domain name associated with my Google Workspace. So I wonder if I'm having an issue related to #6858

The above code mentions "in the future auto-migrating" these accounts. Has anyone run into this issue and solved it manually? I assume something needs to be changed here in the database, either in reference to my user or the provider that is preventing from me from logging in for OIDC SSO.

[oakbrad]

I'm not sure what my specific issue was, but I poked around in the database a little bit and dropped all records from the authentications table that matched my account's user ID and am now able to login with SSO as expected.

DELETE FROM public.authentications WHERE id="myid-string"