The Database Programmer: Advanced Table Design: Secure Password Resets(database-programmer.blogspot.com)
database-programmer.blogspot.com
The Database Programmer: Advanced Table Design: Secure Password Resets
http://database-programmer.blogspot.com/2008/09/advanced-table-design-secure-password.html
3 comments
He's fighting the wrong battle.
He's sending the hash by email! And then working so hard at securing the wrong part of the process - with SSL of course, when email is not encrypted.
He's sending the hash by email! And then working so hard at securing the wrong part of the process - with SSL of course, when email is not encrypted.
The technique presented today makes full use of database server abilities to create a password reset system that is highly resistant to forgery, interception, and evil-admin meddling.
If you for a second honestly believe that this design will stop admins from being able to tamper with the process, you should be fired on sight.
If you are going to design a secure process, I'd say you should focus more on security outside your system, and worry less about keeping admins out. If you're an admin, you have full access, or the ability to give yourself the full access needed to tamper with this system.
If you for a second honestly believe that this design will stop admins from being able to tamper with the process, you should be fired on sight.
If you are going to design a secure process, I'd say you should focus more on security outside your system, and worry less about keeping admins out. If you're an admin, you have full access, or the ability to give yourself the full access needed to tamper with this system.
not so fast. There are companies whose data is very sensitive. Financial, highly sensitive law firm documents, etc. And a large of percentage of data thefts is from inside jobs.
Not everybody is doing only web 2.0, where the data secrecy is not a big deal.
Not everybody is doing only web 2.0, where the data secrecy is not a big deal.
... and carefully vet who your admins are.
Most web applications don't bother with database security - it muddles the logic and prevents things like pooling, scale, etc
For more traditional web apps - typically you have two sources accessing the database - the Web Application and the Administrators. Both of which have access to nearly everything anyway.
This might stop some malicious code from accessing the database improperly - but the fact is, if someone can manipulate the code you've already lost anyway (they could simply just capture the passwords at entry for example).