One user may complain about ORA-28008 when changing its old password in 19c.
Many users still use the old non case sensitive passwords. Resetting User Passwords That Use the 10G Password Version is a post-upgrade task of 19c.
Let’s try with the identified by values (as I wrote long time ago there alter-user-identified-by-values-in-11g )
SQL> create user u identified by values '18FE58AECB6217DB' /* password U */;
User created.
SQL> grant create session to u;
Grant succeeded.
SQL> select PASSWORD_VERSIONS from dba_users where username='U';
PASSWORD_VERSIONS
-----------------
10G
SQL> conn u/U
Connected.
SQL> alter user u identified by ************ replace U;
alter user u identified by ************ replace U
*
ERROR at line 1:
ORA-28008: invalid old password
SQL> password
Changing password for U
Old password: u
New password: ************
Retype new password: ************
Password changed
SQL> conn / as sysdba
Connected.
SQL> select PASSWORD_VERSIONS from dba_users where username='U';
PASSWORD_VERSIONS
-----------------
10G 11G 12C
You cannot use the REPLACE clause, but the sqlplus command PASSWORD still works.
PS: after having earnt a total less than 100 USD of advertissement for over 1000 USD of hosting in the last 20 years, I gave up with AdSense today. Enjoy AddFree