Personally, I'd

DROP USER username CASCADE;

and then re-create the user as it was. Quickest and most simplistic.