The advice and recommendations given here in the community are incorrect. First of all, updating the database user, using the select statement mentioned will fail, as the user's password is encrypted if the database has encryption in use (most enterprise…