The University of Aberdeen, shockingly, does not have a student union - there's the aforementioned 'Hub', which is essentially a canteen, a cafe, a Subway, and some shops that were previously in other locations on campus (a gigantic waste of money, essentially!). You might have more luck with RGU.