Sociology professor to stand down after university announces investigation into his qualifications and career