Alcohol Consumption and Security Clearances

When does drinking become a security concern? Alcohol is legal and its consumption, regardless of quantity, does not by itself trigger a security concern.