A user created without a password, or modified to have no password, cannot subsequently be modified to have a password. The MODIFY USER AS PASSWORD=mypassword statement is not permitted for a user without a password, and returns an error.
MODIFY USER existinguser AS WITHOUT PASSWORD; -- The following MODIFY USER statement is not Allowed -- -- Error message: "Password change not allowed for externally authenticated user" -- MODIFY USER passwordlessuser AS PASSWORD=mypassword;