Cheatle resigns after Trump security failure