Salt/Hash columns?

[SteveHi]

Hello

At the moment, I have a simple online table (MS Access 2007) with two columns:

I am proposing to salt/hash the user's password, so would I need to set up my table like this:

And if I do set up my columns as above, do I delete that password column altogether as storing plain text passwords is not acceptable due to hacking?

Thank you.

Steve

 

[gemma-the-husky]

you would not want to store the plain text password.

either use a encrypt/decrypt function that can derive the plaintext from the encrypted password - or store a hashed version of the password.

given that on line hashtables might divulge commonly used plaintext passwords, if you just do a MD5 hash on the password, you probably need to also do some other tricks with the password before generating the hash.