Two-Beer Joe

A name for a person who acts like a jackass while drinking

You’re a real two-beer joe when you drink.
Quit being a two-beer joe, you’re acting like a dick.