How are passwords stored?

02 Jul 2017

Disclaimer : I do not claim expertise in what I'm writing about. The goal of this post is to give an extremely high level view on how passwords work. The details like choice of algorithms to use for hashing, salting etc. is beyond the scope of this article (and beyond my knowledge). Feel free to correct me if anything seems off.

attacker : A malicous entity who wants to get access to user's real passwords. An attacker could be a rogue developer or an external person.

secure : A method of storing passwords is considered secure if the attacker cannot know user's real passwords even after having access to the database.

service : A website/app which requires user to login.

Storing user passwords as is

This is a no brainer. No sane service stores passwords as is. If an attacker gets access to the database, they have the password of every single user using the service.

One way hash

A simple workaround for this problem is to use a one way hash. So if my password is 'really', then the database stores hash('really') as my hashed password. When a user enters the password, the hash(password) is matched against the one in the database.

So the database contains the following fields

user_id

password_hash : hash(password)

If an attacker gains access to the database, they have hash(password). But because the inverse to the hash is not known nothing can be done (not really!)

However, many users have naive passwords and the hash values for these passwords are known - E.g oranges - 91b07b3169d8a7cb6de940142187c8df. So when an attacker gets access to the database, they will match the hashed passwords against these known hash values and gain access to those accounts which have known passwords. This is called Rainbow table attack.

Salted one way hash

The problem with the previous approach is that the hash of certain passwords is known. This means it is not entirely true that the inverse of the chosen hash function is not known.

Salting is a well known technique which beats this. A salt is random data that is used as an additional input to the password. Every user will be assigned with one salt and this will be stored in the database. Note that the salt value should be generated by a strong random data generator. A relevant discussion on stack exchange - What should be used as a salt?.

Salt and the password are hashed together and the result is stored in the database. Essentially we are transforming the user's password to something stronger. Example : If my password is 'really' and the salt is 'az@sd3a=', the hash('reallyaz@sd3a=') is stored in the database.
So the database contains the following fields

user_id

salt

salted_password_hash : hash(salt, password)

If an attacker gains access to the database, they have salt and hash(salt, password). But this is not enough to retrieve the actual user password. Hence this data is secure.

That said, brute force is always an option. In theory, an attacker can compute hash values of all strings of size <= 30 and thus be able to know passwords of almost all the users. But that is extremely expensive and not many have the access to such compute power. One way to safe gaurd against this is to use an expensive hash function. This makes brute forcing practically impossible.

Conclusion

From what I understand, using a slow hash function on salted passwords is the best that can be done to safely store user credentials. It is worth noting that, a typical developer does not have to deal with these low level details. There are nice libraries which abstract away all this complexity for developers. E.g - passlib, libsodium.

Note to users

Avoid any website which says it can retrieve your old password, if you forget it.

Try not to have a common password for multiple websites. All it takes is one leak!