Team disobeying John's orders

[vacilicamalfoy.livejournal.com]

I'm wondering, are there any stories where the team disobeys John or Elisabeth? I mean, Teyla is used to being the uncontested leader of her people, surely at one point or another, she must have had problems obeying orders she didn't agree with?
Or Rodney, being a civilian who's smarter than John, and slightly arrogant, must have had problems obeying if he thought John was making a mistake?
Even Ronon, while used to the military way, must have had difficulties when the Eartheners were arrogantly messing with things (like Michael), and ignoring his advice even though he knew much better what he was talking about?
Also there's so many stories where John's sexual frustration or anger after Doranda makes him endanger Rodney in the field, while Teyla and Ronon sort of look on vaguely disapprovingvly. Are there any stories where they actually put their foot down? Tell him to straighten up his act right now, or they'll report him?
This is NOT character bashing against John, I like him, just wondering if there's any such plots?