News for hackers. Stuff that matters.

A comment on Using FOIA Data and Unix to halve major source of parking tickets. Parent comment

Re:Using FOIA Data and Unix to halve major source of parking... by ir0nic on Monday August 13, 2018 @08:37PM (#17754746)
Now wouldn't it be funny if you got them to drop a table this way?
[ Parent | on HN ]
Re:Using FOIA Data and Unix to halve major source of parking... by arenaninja on Monday August 13, 2018 @08:52PM (#17754817)
Wouldn't you assign readonly permissions to the account used to fulfill these requests?
[ Parent | on HN ]
Re:Using FOIA Data and Unix to halve major source of parking... by johndavidback on Monday August 13, 2018 @10:32PM (#17755187)
Ideally, but until someone asks for it the first time, they probably don't even have an account for the purpose. So, an irritated DBA who has myriad other backlog tasks probably runs it on a copy if smart, and production if lazy or in a hurry. Would not surprise me in the slightest if an important table was dropped in this way.
[ Parent | on HN ]
Re:Using FOIA Data and Unix to halve major source of parking... by xapata on Monday August 13, 2018 @11:20PM (#17755366)
Yes, but if they're not sanitizing inputs, they might not have set permissions wisely either.
[ Parent | on HN ]