Problem
How to extend the user password when expired.
Solution
To extend the password of the admin user for 3 months, for example, use the following command (MYSQL and ORACLE):
UPDATE TB_USER SET `PASSWORD_CHANGE_DATE` = DATE_ADD(`PASSWORD_CHANGE_DATE`, INTERVAL 3 MONTH);
COMMIT
To check the expiry date of all the users
Select PASSWORD_CHANGE_DATE, USER_NAME from TB_USER;