At sea, you were limited to not more than two beer or glasses of wine. You could not consume alcohol 6 hours before a watch (12hrs for aircrew) and were never permitted to be intoxicated.
For certain operational sails (Most CJOC operations), alcohol consumption was not permitted at sea and even in port, in some cases.
Alongside, there were no limits on alcohol consumption, as long as you were not on duty, within published bar hours and did not breach the general CF provisions on drunkeness and misconduct.
So, there have always been perfectly serviceable control measures. As long as they were enforced.