Re:Innovative way to combat SQL injection
by gluejar on Thursday May 13, 2010 @04:32PM
(#1345559)
In case you have any confusion about this, please note that the term "Innovative" is used here to mean "likely to cause Hacker News readers to spew soda out their noses".
[ Parent
| on HN ]
Ooops - looks like somebody forgot to put "TRUNCATE" in the list!
It is possible that they server is not given access to these functions, so they didn't need to be checked for, in the input.
This presents its own problems, if for some reason in the future they need to add one of these missing functions to the servers access, and don't recognise that they need to add the check as well.
But anyway, it is great to see the boss' nephew getting some work.
Come on. Typing "truncate" in a text field doesn't do anything to the database. Neither does "insert" or "update".
What it does is generate stupid alarms and break pageflows when you have an improperly configured web filter.
Re:Innovative way to combat SQL injection
by redangstrom on Thursday May 13, 2010 @06:36PM
(#1345937)
Indeed! And "alter table", "create view", etc... I'm glad I didn't joint that credit union when I considered it a few years ago.