I expect this will attract a lot of criticism, but I actually think it's a good idea, at least in some cases. There are a lot of people writing bad code and bad system architectures for their organizations. There are not enough people with the competence, organizational power, and time to catch what's bad and force change in those organizations. In the US you are probably forced to do business via many such terribly…
Password may not contain: select, insert, update, delete, drop
61–70 of 254 posts
Re: Password may not contain: select, insert, update, delete, drop
#62Earlier quoted context omitted.
Nope - that's not a valid ldap URL - or even a valid domain, for that matter. Domains can only contain the ascii leters a-z and the digits 0-9 -- asterisks are not permitted; the only symbol permitted is a hyphen (and it cannot start or end with one).
It's a log4shell reference
Re: Password may not contain: select, insert, update, delete, drop
#63Earlier quoted context omitted.
That would imply WAF gets to see unhashed passwords, so not good at all.
How would a WAF do its job if it can't see the request payload?
Re: Password may not contain: select, insert, update, delete, drop
#64still better than "password used by another account"
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 with a legacy/cargocult system.)
Re: Password may not contain: select, insert, update, delete, drop
#65I expect this will attract a lot of criticism, but I actually think it's a good idea, at least in some cases. There are a lot of people writing bad code and bad system architectures for their organizations. There are not enough people with the competence, organizational power, and time to catch what's bad and force change in those organizations. In the US you are probably forced to do business via many such terribly…
But why would you ever send a plaintext password into a sql query?
Re: Password may not contain: select, insert, update, delete, drop
#66Re: Password may not contain: select, insert, update, delete, drop
#67I expect this will attract a lot of criticism, but I actually think it's a good idea, at least in some cases. There are a lot of people writing bad code and bad system architectures for their organizations. There are not enough people with the competence, organizational power, and time to catch what's bad and force change in those organizations. In the US you are probably forced to do business via many such terribly…
If an organization has such a password policy, that can be interpreted as the person in charge of setting this policy thinks their organization doesn't have enough people with the competence and organizational power to prevent SQL injection vulnerabilities. Which would reflect poorly on any institution, but especially a university (which should be a bastion of people with competence and organizational power). As for…
EDIT: as they don't actually check for all the banned strings, the "auditor + mandatory misconfigured WAF" hypothesis expressed above is not valid in this case. But let it stay as an otherwise-plausible explanation, or maybe something that was valid in the past.
Re: Password may not contain: select, insert, update, delete, drop
#68Re: Password may not contain: select, insert, update, delete, drop
#69Obligatory meme-y "tell me you're not sanitizing input without telling me". Also not storing hashes of passwords, because then it wouldn't matter what the input is.
Thinking about it, it can also be that the input is sanitized a little too much. Imagine the user uses "select_mypassword" as a password. The sanitizer kicks in and silently mangles your password, resulting in another password being stored than the one you entered, effectively locking you out. Or maybe it just fails with an obscure error because some overzealous countermeasure triggered. I wonder what using the EICAR…
Hopefully you don't actually have to do any of this because your backend wasn't written by monkeys on typewriters.
Re: Password may not contain: select, insert, update, delete, drop
#70I want more innovation in the password requirement genre: Your password must be valid SQL, Java, Go, or C++ string. Or a haiku about grocery shopping. This way it won’t look like a password in case we leak it.