Grant misses penalty in stoppage time to earn rare win at Pittodrie