Someone who has something up their butt. Tight asses generally don't enjoy anything fun, spontanious, or interesting.
Matt: Hey, do you want to come to a party with me tonight? We're going to get so wasted!
Jack: No thanks, what if we get in trouble!
Matt: Whatever. Stop being such a tight ass.