In Australia the general view is that its a medical issue and with the appropriate treatment , monitoring and medical and psychological clearances for alcohol abuse, the pilot is given a second chance. Third chances are much rarer. Other recreational drugs are treated with much less tolerance. Certain substances are zero tolerance.