I'm thinking my way through the give and take so bear with me
In a hospital, different parts of our medical records are accessible by different personnel. All Rx are input by anyone able to prescribe. The pharmacy sees all of them.
All pharmacies everywhere see every prescription they've filled, for the last five years I think. They oversee our safety with the product they dispense, along with making sure medical/government guidelines are being met.
They don't see all of our prescriptions from everywhere, but insurance agencies do, as does the government when it comes to taxpayer funded programs.
There's a disconnect between all pharmacies, insurance agencies, and the government. It's costing us lives. It doesn't even have to be a narcotic for it to be deadly.