One of my roommates in college had a brother at Auburn. For one of the AU game one year he and a friend drove up. While tailgating, his friend got pretty far gone. He was standing with a can, no coozie being obnoxious. Cop walked up and told him to pour it out. He looked confused, poured it out, and reached into the cooler, grabbed another can and opened it. He got in some trouble, but as long as you're not being obnoxious you'll be fine.
Cops want to look the other way on gameday. You just have to give the chance because they also have to do their jobs.