IBM Maximo: BMXAA4038E - Cannot log in to perform this action on Forgot Password link: Difference between revisions

From Wiki
No edit summary
No edit summary
Line 1: Line 1:
Get properties
= Checking the system properties =


  SELECT PROPNAME,SERVERNAME,PROPVALUE,ENCRYPTEDVALUE
  SELECT PROPNAME,SERVERNAME,PROPVALUE,ENCRYPTEDVALUE
Line 23: Line 23:




Get user
= Check MAXREG user =


  SELECT USERID,STATUS,PASSWORD,LOGINID
  SELECT USERID,STATUS,PASSWORD,LOGINID
Line 38: Line 38:
|}
|}


= check if MAXREG user is on MAXREG group =


  SELECT USERID,GROUPNAME FROM GROUPUSER WHERE USERID IN ( SELECT USERID FROM MAXUSER  
  SELECT USERID,GROUPNAME FROM GROUPUSER WHERE USERID IN ( SELECT USERID FROM MAXUSER  
Line 54: Line 56:
|}
|}


= Check permissions to FORGOTPSWD application =


  SELECT GROUPNAME,APP,OPTIONNAME FROM APPLICATIONAUTH WHERE APP ='FORGOTPSWD'  
  SELECT GROUPNAME,APP,OPTIONNAME FROM APPLICATIONAUTH WHERE APP ='FORGOTPSWD'  

Revision as of 07:40, 4 October 2023

Checking the system properties

SELECT PROPNAME,SERVERNAME,PROPVALUE,ENCRYPTEDVALUE
FROM MAXPROPVALUE
WHERE PROPNAME IN ( 'mxe.system.reguser', 'mxe.system.regpassword','mxe.convertloginid');

Result

PROPNAME SERVERNAME PROPVALUE ENCRYPTEDVALUE
mxe.convertloginid COMMON 1 (null)
mxe.system.regpassword COMMON (null) 65...27
mxe.system.reguser COMMON MAXREG (null)

In property mxe.system.reguser the value must be CAPITALIZED



Check MAXREG user

SELECT USERID,STATUS,PASSWORD,LOGINID
FROM MAXUSER
WHERE loginid IN ( SELECT PROPVALUE FROM MAXPROPVALUE  WHERE PROPNAME IN ( 'mxe.system.reguser')) ;

Result

USERID STATUS PASSWORD LOGINID
MAXREG ACTIVE 461...70 MAXREG


check if MAXREG user is on MAXREG group

SELECT USERID,GROUPNAME FROM GROUPUSER WHERE USERID IN ( SELECT USERID FROM MAXUSER 
WHERE loginid IN ( SELECT PROPVALUE FROM MAXPROPVALUE  WHERE PROPNAME IN
( 'mxe.system.reguser')) ) ;
USERID GROUPNAME
MAXREG DEFLTREG
MAXREG EVERYONE
MAXREG MAXREG

Check permissions to FORGOTPSWD application

SELECT GROUPNAME,APP,OPTIONNAME FROM APPLICATIONAUTH WHERE APP ='FORGOTPSWD' 
AND GROUPNAME IN ( SELECT GROUPNAME FROM GROUPUSER WHERE USERID IN ( 
SELECT USERID FROM MAXUSER WHERE loginid IN ( SELECT PROPVALUE FROM 
MAXPROPVALUE  WHERE PROPNAME IN ( 'mxe.system.reguser')) ) 
);
GROUPNAME APP OPTIONNAME
MAXREG FORGOTPSWD READ
MAXREG FORGOTPSWD INSERT
MAXREG FORGOTPSWD SAVE
EVERYONE FORGOTPSWD READ
EVERYONE FORGOTPSWD INSERT
EVERYONE FORGOTPSWD SAVE

Ver também

Retrieved from "https://ebasso.net/wiki/index.php?title=IBM_Maximo:_BMXAA4038E_-_Cannot_log_in_to_perform_this_action_on_Forgot_Password_link&oldid=8400"