A Paralympic gold medallist rower has been awarded an honorary golf club membership.