10 CFR 26.75:
(c) Any individual who is determined to have been involved in the sale, use, or possession of illegal drugs or the consumption of alcohol within a protected area of any nuclear power plant, within a facility that is licensed to possess or use formula quantities of SSNM, within a transporter's facility or vehicle, or while performing the duties that require the individual to be subject to this subpart shall immediately have his or her authorization unfavorably terminated and denied for a minimum of 5 years from the date of the unfavorable termination of authorization.
Based on that, I would say your friend has at least three more years before he's eligible anywhere.