Users with a little bit of knowledge are liken to a stick of dynamite in a match factory.:-D

Grant,

What would be the purpose of moving the query capability off of the production server?

Wouldn't that just still require granular permissions that would still apply elsewhere?

Looks like it...

Thanks to ZZ, Jason and Grant

first and foremost queries were limited to previous IT manager. everything else was accessed by custom reports through SSRS, SharePoint, and the ERP which were...