This is why teachers with CCWs need to be authorized to carry on the job. Teachers know the kids, have relationships with them, and therefore care about their safety. Resource Officers tend to be aloof with regard to the kids, and don't seem to have attachment to them. They are therefore more likely to think in terms of getting home safely at the end of their shift than protecting the students from a dangerous shooter.
