Let $h\colon R\rightarrow S$ be a morphism of commutative rings. We consider the following functors (I am aware that the notations may be different in other contexts):
$h^*$: Scalar extension by means of $h$, i.e. $h^*(M)=M\otimes_RS$;
$h_*$: Scalar restriction by means of $h$;
$\widetilde{h}$: Scalar coextension by means of $h$, i.e., $\widetilde{h}(M)={\rm Hom}_R(S,M)$.
These functor form the adjoint pairs $(h^*,h_*)$ and $(h_*,\widetilde{h})$. Moreover, using some general nonsense one can show that the following statements are equivalent: (i) $h^*$ has a left adjoint; (ii) $\widetilde{h}$ has a right adjoint; (iii) The $R$-module $h_*(S)$ is projective and of finite type.
So, suppose that (i)-(iii) are fulfilled. My question is then:
What are the left adjoint of $h^*$ and the right adjoint of $\widetilde{h}$?
ADDENDUM: It is a result of Morita (Theorem 4.1 in K. Morita, Adjoint pairs of functors and Frobenius extensions, Sci. Rep. Tokyo Kyoiku Daigaku Sect. A 9 (1965), 40--71) that (still under the above conditions (i)-(iii)) $$h^*\cong\widetilde{h}\quad\Longleftrightarrow\quad\widetilde{h}(R)\cong S.$$ Therefore, it remains to consider situations where $\widetilde{h}(R)$ and $S$ are not isomorphic.