I work in this space, building the tools to help LEAs seach their databases. I also have conflicting feelings about how this could be used. We built in access control down to the specific camera, auditing of every user action, requiring the reason you are performing an action, and mandating the user associate an open case in the same access group as the camera you are querying in order to view the data.

Its pretty locked down to help prevent abuse. I'm not saying abuse is impossible but LEOs or more likely, their administrators, but it is difficult to do it and get away.

I've heard from the higher ups, that abuse used to be rampant in other systems, but since switching to our software, only a handful of people have been found to abuse it.