Live data from Hacker News

Password may not contain: select, insert, update, delete, drop

id.uni-lj.si

251–254 of 254 posts

Re: Password may not contain: select, insert, update, delete, drop

#251
post #249

Earlier quoted context omitted.

No, it isn't. If a user's password leaves the web application in any form other than a hash, something nonstandard and probably bad is going on.

Hashing is hardly ever done client side. Most often server side, which is fine, because it's not the same as "storing plain text". In fact, if you rely on client side hashing, you are not only making the app a lot less accessible (it will only work with JS enabled), the security is worse, because now you are publishing a salt to the client. Or you are working with unsalted hashes which is hardly better than just plai…

I think you may have misunderstood me. By "the web application" I mean the application server, not client-side code.

Re: Password may not contain: select, insert, update, delete, drop

#252
post #64

Earlier quoted context omitted.

Not sure if serious. We need this. If you can guess someone else's password by accident, both of you need a password reset and that password needs to go on the denylist. Modern advice for strong passwords is having a length requirement and checking the input against a list of known passwords, for example using the HIBP partial hash API. (Any time you see forced expiration or complexity requirements, you're dealing wi…

The server shouldn't even be able to know that a password is being reused as it should be hashed and salted there is no situation where this would be acceptable

Ah yeah that's true, I forgot that it's computationally complex to check that against a whole user base

Re: Password may not contain: select, insert, update, delete, drop

#253

Earlier quoted context omitted.

That still introduces a fairly serious vulnerability. The lack of salting on the "password uniqueness" database makes it a juicy target; an attacker with access to the database can attack those passwords, then try the ones which are known to be valid from there against the salted passwords in the user database.

I wonder if there’s some way to mitigate this by either only keeping the uniqueness database long enough to identify duplicates and then deleting it or by using this on lower priority systems that people may reuse passwords from for your higher security one. In either case, the small number of bad passwords you would identify that you couldn’t come up with yourself or find on common password lists probably makes this…

[deleted]

Re: Password may not contain: select, insert, update, delete, drop

#254

Can not contain "script". I hacked a big social platform in my early teens (Nettby.no), since they just did a removal of all banned words, including . I instead wrote ipt> in my profile bio, and after their removal I had a valid html tag injected into the webpage and full control of anyone visiting my page..

LOL. I did the same thing with a Coca-Cola site and their MD wrote me a nasty letter and removed my account.
Post reply on HN