It's awful. Has your husband's superiors thought about providing their front-line staff with a de-escalation training? There are a few different programs that are trauma-informed and intended to help de-escalate situations and, when necessary, use hands-on or restraints to keep everyone safe. One is CPI (
https://www.crisisprevention.com). This is used in a lot of schools. I was able to (with a team) restrain a 21 year old boy who was 6'3 (I'm 5'3). It also taught how to de-escalate a situation before it gets to the point of needing restraints and boils down to an anxiety response in the other person.
Re: opiates & heroin. A lot of people start using opiates (ex. Oxy) when it is prescribed for some sort of injury or chronic pain. The more they use it for the pain, the less it works and the more expensive it gets as they build a tolerance. Heroin is cheaper and gives the same effect.
Narcan (which in some states can be bought over the counter and carried by anyone) basically revives someone who ODed. Unfortunately it's a quick fix and the person can get up and walk away and use again. There's not necessarily follow up.
Vivitrol and Suboxone are used to help manage the addiction. It basically stops cravings/doesn't let your body feel the high if you do use. Unfortunately, this makes using while being treated with these very dangerous. If someone uses while taking Vivitrol or Suboxone, they can't get the high from their usual dose of Heroin, so they use more, which can cause them to OD.
Finally, the most dangerous time for someone who is addicted is right after they withdraw and get clean. They'll go to use and take their usual dose, which their body can no longer tolerate, which can cause them to OD on what they've taken many times before without ODing.