[oytis]

Your email is your identity. If they allow you to change your email, what they should refer you by, your passport number? Was kind of easier in the times of usernames, but these are long gone

[wizzwizz4]

They should use the integer primary key of the users table, of course.

[piskov]

Nah, that’s too 1985.

Because client doesn’t know it, inserts can be slow in cross-db environment.

Guid is always better (can be client generated), and modern guid versions can be ordered chronologically

[TZubiri]

That's probably an implementation feature that is hidden and not dependable if it exists at all.

[oytis]

Please enter your integer primary key and password to log in.

[esafak]

You can use a random numerical ID as PK and let people associate as many authn IDs as they want after logging in with one.

[Reubachi]

Who in this scenario outlines the key infrastructure, and how is the private key maintained?

[esafak]

primary key. https://en.wikipedia.org/wiki/Primary_key

[thiht]

Why would you allow this complexity for basically nothing?

[esafak]

Using a separate table for authn is a basic pattern for this problem. What would you do?

[lxgr]

Most services I know allow changing both.