The Dubai executive council published a code of conduct. As long as the person is not behaving as if drunk or outside a licensed venue, drinking alcohol is not indicated as being prohibited. A license seems to be legally required if buying alcohol from a retail store or wholesaler but is more ambiguous about buying it for on-site consumption at a venue with a drink service license.
So no license needed to drink, but maybe a license to buy.