An ex-Home Affairs official has been convicted after a scandal involving sensitive information, in what has been called “quite a fall from grace”.