The acting Social Security Commissioner resigned after 32 years following Elon Musk aides accessing sensitive records