In general, passengers are permitted to drink pretty much anywhere and can take a drink from a bar and walk with it to their cabin or other onboard location. That said, most cruises are not drunken booze fests. You might come across someone who has had a few too many, but most passengers will be well behaved.