There are tons of examples of just that happening. The most prominent one might be Aldrich Ames, but there's a lot more.