"Oracle" ora-28002 a workaround that prompts the user for a password that is about to expire

---1, first check the user's profile in the user password life cycle, in general, the default is 180 days. When logged in, the system prompts ora-28002 that the user is about to expire

--If we do not want to change the password, we can modify the Oracle configuration file

SELECT *  from WHERE resource_name='password_life_time';

---2. Change the default profile password policy to unlimited (UNLIMITED)

Alter default limit Password_life_time Unlimited; SELECT *  from WHERE resource_name='password_life_time';

--3, if you modify the profile when the user has the prompt or need to change the password, keep the original password, the user will no longer prompt

Alter User  by PASSWORD;

Finally, you can log in again, and the ora-28002 prompts no longer appear.

"Oracle" ora-28002 a workaround that prompts the user for a password that is about to expire