Alter User Identified By Inquiry

Question

Inquiring if the statement after identified by is the password 'pw12334' to be applied to the account example Alter user username identified by pw1234 account unlock.

also inquiring if "identfied by" command alone can replace password without the "replace" command

kinda confused here, since I need to apply the password to apex.xml to make the ords 503 error go away.

Answer 1

the syntax to unlock the user is, the IDENTIFIED BY password is needed becuase if you unlock an account without resetting the password then the password remains expired.

 ALTER USER james IDENTIFIED BY Jim123 ACCOUNT UNLOCK;