When a user name has a profile that has a password verify function set and the user tries to change the password using “ALTER USER” without the REPLACE clause, and also the user doesn’t have ALTER USER privilege Oracle will generate the “ORA-28221: REPLACE not specified” error message. So the user needs to include the “REPLACE” clause.

Example:
ALTER USER <username> IDENTIFIED BY <new password> REPLACE <old password>

One response to “ORA-28221: REPLACE not specified”

  1. KK Avatar
    KK

    Thanks…this helped.

    Like

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.