Funnily enough I watched an interview of a Bass player by a drummer. Both professional players. The drummer's aim of the series of interviews was to find out what musicians wanted from drummers and various general tips.
The bass player pointed out there was a difference between substance use and substance abuse. And that it's a fine line. He'd never seen anyone fired for not having a beer on stage with them, but seen plenty not hired again for just having a single beer. This was the US though and they can have very puritanical views.