It depends. If someone is feint am asshole and tearing down the team, a “knock it off or else” approach is certainly a reasonable response, especially if done privately.
I'm not a manager, I'm a lead / pe. This is over 22 years that it's happened 4 times. 2 were at drinks and 2 were at mentoring sessions, all 4 were kinda struggling and looking for a safety net.