Allow Invite for specific provider

[NiroHaim]

As an admin, I would like to be able to invite users not only for the default provider: "Email", but rather to be able to control to which provider the user is expected to use.

Problem caused without feature:

How my app auth works

• My app is multi-tenancy in which RLS is active for all tables.
• I have 2 auth methods:
  • Username + password with MFA.
  • Google SSO.
• Each table contains a tenant_id.
• Users can only read from a table if their user id is referenced in a tenant_user table and connected to a tenant.

Inviting a user

To add users I invite them using the Supabase studio. This creates a user id which I can then take and add to the tenant_user table.

Where this breaks

The default provider during an invite is: "Email".
When I want to allow a user to join an organization with Google SSO logon, I can't invite him and add him to the tenant_user table because his provider is Email and he tries to sign in using Google SSO.
Instead, I need him to try and sign in with Google SSO, this creates a user with provider: "Google" and only then, can I take the new user id and add it to the table.