If he was in an area where it couldn't have harmed anyone, no problem. But I say haul the drunk off to jail.
There's a reason most cities have ordinances against discharging firearms within city limits. One of the least of which is that bullets can ricochet when fired at hard steel.
