Deleting Maximo Application

Deleting Maximo Application

Deleting an application in Maximo is not possible from Front End and it's not advisable too. You can remove the security rights of that application so that it doesn't appear in Go To list.

Still, if you want to delete an Application in Maximo, you have to accomplish it using SQL Scripts which will be executed in the back-end.

Following are the scripts:

delete from maxapps where app='<appName>';
delete from maxpresentation where app='<appName>';
delete from sigoption where app='<appName>';
delete from applicationauth where app='<appName>';
delete from maxlabels where app='<appName>';
delete from maxmenu where moduleapp='<appName>' and menutype !='MODULE';

To remove Label information from database, run the following queries:

delete from L_SIGOPTION where L_SIGOPTIONID in (select L_SIGOPTIONID from SIGOPTION,L_SIGOPTION  
  where (SIGOPTION.SIGOPTIONID=L_SIGOPTION.OWNERID AND app='<appName>'))

delete from L_MAXLABELSID where L_MAXLABELSID in (select L_MAXLABELSID from MAXLABELS,L_MAXLABELS
  where (MAXLABELS.MAXLABELSID=L_MAXLABELS.OWNERID AND app='<appName>'))

delete from L_MAXMENUID where L_MAXMENUID in (select L_MAXMENUID from MAXMENU,L_MAXMENU where (MAXMENU.MAXMENUID=L_MAXMENU.OWNERID AND moduleapp='<appName>'))

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...