Revision as of 07:01, 4 October 2023

Get 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 mxe.system.reguser, the value must be capitalized

Get 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

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

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

@@ Line 15: / Line 15: @@
 | mxe.system.regpassword|| COMMON || (null) || 65...27
 |-
-| mxe.system.reguser || COMMON || MAXREG || (null)
+| mxe.system.reguser || COMMON || '''MAXREG''' || (null)
 |}
+'''In mxe.system.reguser, the value must be capitalized'''
 Get user