Only Frodo gave into the temptation while the ring was in his possession.

And, afaik, that was because the Ring was at its most powerful - facing imminent destruction is when the Ring goes all in with the influence.