In the hotel room - in all the emirates. In restaurants, bars and nightclubs - in all emirates, except for Sharjah. There is a "dry" law,

Only in the emirate of Sharjah does the "dry" law operate. That is, alcohol is not sold in stores and is not served in stores hotels

But tourists can bring it with them or travel to other emirates for buying alcohol