We have more than 170 users in autosys_secure user@host in an old WA AE 11.3 SP1 instance used for running jobs.
We have installed WA AE 11.3.6 SP5 on a new machine and we need to get the users and their passwords from the old instance.
So we copied over the ujo_cred table from the 11.3 SP1 instance to the 11.3.6 SP5 instance. But when we go to autosys_secure, Manage users, Manage users with password, Show all users, we can find only the users created originally in the 11.3.6 SP5 instance.
We cannot recreate users directly in the new WA AE 11.3.6 SP5 instance because for security reasons we do not have access to the users passwords.
We cannot interrupt our production the time necessary for creation of users and their passwords.
The 11.3 SP1 and 11.3.6 passwords encryption are compatible.
You cannot see the users imported from 11.3 SP1 because of a difference in the tables content.
The solution will be to run the following query to fix the difference between 11.3 SP1 and 11.3.6 release:
update aedbadmin.ujo_cred set cred_type = 4 ;
After the above queries, you will be able to find back all your users and passwords.
Problem resolved by applying the solution.