In which I offer an exremely mild restriction on gun ownership that even the NRA will love!

This story from Altoona PA in which a drunken man, armed with a gun, managed to shoot himself whilst trying to shoot bees (really - he was) set me to thinking. Would it be too much to ask that it should be possible to remove from an individual the "right" to carry weapons, possess weapons or live in a household containing weapons after they are found to be in possession of weapons (or at least found to have used weapons) whilst under the influence of alcohol* or illegal drugs? Surely no one could object to that could they?

*The drink driving standard could be used for those old enough to drink whilst zero tolerance should be imposed for illegal drugs and alcohol for the underage.