Technically - Yes. America can refuse a visa if they feel he is habitual drunkard. That’s one of the questions on the adjustment of status application that comes later. Now at his interview they may allow him to present evidence he isn’t or they may just reject or they may allow him to just be rejected for a year to prove he isn’t and for those in the past with drug consumption they want to see that he complete testing in that year to show that he isn’t using. This will all hinge upon the embassy and what steps he has taken post conviction - did he complete any kind of rehabilitation, does he still drink, has he any other convictions, etc.