Hello, I am building a multi-tenancy application. We make a platform where merchants can create their own websites and have their own users. We have encountered the challenge that if User A has a user for both Tenant A and B and wants to change their password it will change for login both on Tenant A and B. We are wondering if we should move on to a system where we use Supabase Auth, but store emails like sha256(tenantId+email)@customer.internal and if that causes any problem with Supabase Auth?
We are already using custom auth emails using the auth hook.