Resetting passwords

In the case when the admin password cannot be restored or there is a necessity to reset all the passwords for everyone, users can use the following SQL commands.

UPDATE LOGIN SET PASSWORD='passwd00';
DELETE FROM USER_KEY;
UPDATE MANAGED_SYS SET PSWD = NULL;
DELETE FROM PWD_HISTORY;
DELETE FROM USER_IDENTITY_ANS;
UPDATE SYNCH_CONFIG SET SRC_PASSWORD = NULL;

These will reset all passwords, and when you restart the ESB, a new JKS key will be generated and stored in the vault.

Note: Please do not use the mentioned approach in the production environment.