The functor you mention is faithful if and only if the functor $-\bigotimes_A B :A-mod\to A-mod$ is faithful, ie iff $B$ is a faithful $A$-module.
For a concrete counterexample take $f:\mathbb{Z}\to \mathbb{Q}$ and like Graham says this kills the torsion stuff.