Dubai and the rest of the Emirates have bars and clubs. I’ve drank in the Irish Bar, Carters and other bars. I’ve had drinks in the Birg Al Arab and the Birg Al Khalifa . They take a very dim view of drunkenness but alcohol isn’t forbidden.
Alcohol is forbidden in Saudi, but I drank regularly in the British, Irish and American Embassy clubs.
Cheers.