For people with pain from terminal cancer, Cox-2 inhibitors are no better than sprinkling with holy water. And those people are dying anyhow. You can't eliminate the availability of these drugs entirely and leave that population to suffer without relief. Anybody who has watched someone with terminal cancer suffer knows what I mean.
There are no easy answers. The state can do all kinds of rapid-fire things to make access more restrictive, but if they do it in a stupid fashion (and they usually do) it will do as much harm as good. That said, I don't know what the right way is.