I can't imagine <b>any</b> case where someone else than the user himself should know the password.
By the way: the password is encrypted/hashed in the database - so there is no way to look at it. You'd need to change the user account datatype first - saving the password (additionally) in plain text. Later you can override / extend other templates (in the admin or normal site) to show this.