tight-assed

adj.

Affected by alcohol to the point of impaired vision.

The bartender chuckled as Bennette attempted to order a "martooni", appearing hilariously tight-assed.

Source: Wiktionary