Security Clearance Sex Talk

A common belief conveyed around the security clearance process is that sexual norms have changed so much - how could anything be considered off limits or deemed a risk as a part of the security clearance process?