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