Canadian officers fear US assignments could stall their careers, restrict their security access and meet resistance from families concerned about anti-Canadian sentiment