Re:Hello, I’m Mr. Null. My Name Makes Me Invisible to Computers
by eyelidlessness on Sunday September 04, 2016 @07:56PM
(#12427314)
If they're using prepared statements, they shouldn't be doing anything about SQL injection attacks, as either the prepared statements work or they don't.
[ Parent
| on HN ]
Re:Hello, I’m Mr. Null. My Name Makes Me Invisible to Computers
by dagss on Sunday September 04, 2016 @08:13PM
(#12427369)
Exactly -- "if they are". Are they? How can you, as a manager, know? How can you make 100% sure that every developer to ever work on the code always does the right thing?
Then consider the downside and cost of filtering the input, vs. the downside and cost of injection attack times a probability of 0.01% of a developer messing up -- and a policy, however idiotic it may seem to the individual developer, may make sense on a business level.
Re:Hello, I’m Mr. Null. My Name Makes Me Invisible to Computers
by dragonwriter on Sunday September 04, 2016 @11:24PM
(#12427894)
A manager can just add easily create a policy about prepared statements as create a policy about mangling text to "protect" user input that is being put into SQL queries. And neither is easier to monitor. Adding the second as an additional policy because of uncertainty about compliance with the first is silly -- it bus you nothing where the first is complied with and gets you another monitoring problem. Better to just expend the same additional effort you'd expend monitoring the second policy to just improve monitoring the first policy.
Re:Hello, I’m Mr. Null. My Name Makes Me Invisible to Computers
by dagss on Monday September 05, 2016 @03:12AM
(#12428636)
It seems like you are ready to declare "second line of defense" as a silly thing in principe?
Sometimes adding a second line of defense at 90% efficiency is cheaper than increasing the first line from 90% to 99%.
Re:Hello, I’m Mr. Null. My Name Makes Me Invisible to Computers
by eyelidlessness on Sunday September 04, 2016 @08:28PM
(#12427419)
I was responding to the premise. I was not responding to not the premise. Shrug.