Changing maxadmin Password

Changing maxadmin Password

If you don't know maxadmin password then there is no way to get it from any of the property file or config file in maximo.

Then how can we reset it

Answer is - you have to update it to a known encrypted password in database using sql command.

Pre-requisite: you should have write access to MAXUSER table under maximo schema.

Procedure to reset the password:

1) Go to development or any environment for which you know the password of maxadmin or any user.
2) Run the following command to retrieve the encrypted password of known user

               Select userid, password from maxuser where userid = 'anyUser'
               For example: Select userid, password from maxuser where userid = 'MAXADMIN'

3) Copy the encrypted password
4) Go to the environment for which you don't know the maxadmin passwrod.
5) Run the following command to reset the password. Please note your update sql statement will depend on the database which you are working on due to hexa decimal value format of encrypted password.

         Oracle: UPDATE maxuser SET PASSWORD = '<value>' WHERE userid = '<user>';
         SQL Server: UPDATE maxuser SET PASSWORD = 0x<value> WHERE userid = '<user>';
         DB2: UPDATE maxuser SET PASSWORD = x'<value>' WHERE userid = '<user>';

Example:

         Oracle: UPDATE maxuser SET PASSWORD = '10fe6f4d7e6133e64' WHERE userid = 'MAXADMIN';

         SQL Server: UPDATE maxuser SET PASSWORD = 0x10f2121d7e6133e64 WHERE userid = 'MAXADMIN';

         DB2: UPDATE maxuser SET PASSWORD =x'10fe6f46507e6133e64' WHERE userid = 'MAXADMIN';

Thank you for reading...