To submit a new password for the user using a CLI application, all previously established sessions with the user need to be terminated.
Submit an application as follows:
- Log on to the database with the old username and password.
- Submit a MODIFY USER statement which assigns a new password to the user.