Solution for Oracle DB.
1. Connect from sqlplus or Toad session against STAT DB.
2. delete statuser where userid = 'SYSTEM';
commit;
3. Insert into STAT.STATUSER
(USERID, LAST_NAME, FIRST_NAME, TITLE, PASSWORD,
PASSWORD_CHANGE_DT, PRIMARY_SD, REPORT_AUTH_LEVEL, THRESH_WARN, THRESH_CRITICAL,
STATUS_CD, UPDATE_DT, UPDATE_USERID, RELATED_OBJ, LOG_DIR,
DEL_WRKFILE, PSTOOLS_DIR, DOWNLOADDIR, COPY_FILE, DICTIONARY_LANGUAGE,
USERDIC_DIR, DFLT_CSR_WINDOW, ENABLE_LDAP, LICENSE_TYPE, RESET_PASSWORD)
Values
('SYSTEM', 'Account', 'System', 'Stat System Account', 'fed61c9ce164e04651c6219b5017cb45',
TO_DATE('03/18/1998 16:28:25', 'MM/DD/YYYY HH24:MI:SS'), 'NA', 99, 0, 0,
'A', TO_DATE('01/11/2016 13:27:50', 'MM/DD/YYYY HH24:MI:SS'), 'SYSTEM', 'N', 'C:\TEMP\',
'N', 'PS_HOME\bin\client\winx86', 'C:\TEMP\', 'N', 'ssceam',
'STATHOME', 0, 'N', 1, 'Y');
COMMIT;
** Note: This resets the SYSTEM Stat user per its initial installation.
4. select * from user_svc_domains where userid = 'SYSTEM'; -- It should return 0, before insert the record.
5. Insert into STAT.USER_SVC_DOMAINS (USERID, SD_CD, USER_CLASS_CD, UPDATE_DT, UPDATE_USERID)
Values ('SYSTEM', 'NA', 'Admin', SYSDATE, 'SYSTEM');
COMMIT;
6. Go to User Maintenance, highlight the SYSTEM user, and assign the proper SD (Service Domain).
7. Create New user or Copy the user same SYSTEM (with Admin privilege) and use this user as Stat Admin filling in the email address.
Solution for MS SQL Server DB.
1. Perform the steps below from SQL Management Studio, as SYSTEM.
2. delete statuser where userid = 'SYSTEM';
commit;
3. Insert into STAT.STATUSER
(USERID, LAST_NAME, FIRST_NAME, TITLE, PASSWORD,
PASSWORD_CHANGE_DT, PRIMARY_SD, REPORT_AUTH_LEVEL, THRESH_WARN, THRESH_CRITICAL,
STATUS_CD, UPDATE_DT, UPDATE_USERID, RELATED_OBJ, LOG_DIR,
DEL_WRKFILE, PSTOOLS_DIR, DOWNLOADDIR, COPY_FILE, DICTIONARY_LANGUAGE,
USERDIC_DIR, DFLT_CSR_WINDOW, ENABLE_LDAP, LICENSE_TYPE, RESET_PASSWORD)
Values
('SYSTEM', 'Account', 'System', 'Stat System Account', 'fed61c9ce164e04651c6219b5017cb45',
TO_DATE('03/18/1998 16:28:25', 'MM/DD/YYYY HH24:MI:SS'), 'NA', 99, 0, 0,
'A', TO_DATE('01/11/2016 13:27:50', 'MM/DD/YYYY HH24:MI:SS'), 'SYSTEM', 'N', 'C:\TEMP\',
'N', 'PS_HOME\bin\client\winx86', 'C:\TEMP\', 'N', 'ssceam',
'STATHOME', 0, 'N', 1, 'Y');
COMMIT;
4. select * from user_svc_domains where userid = 'SYSTEM'; -- It should return 0, before insert the record.
5. Insert into STAT.USER_SVC_DOMAINS (USERID, SD_CD, USER_CLASS_CD, UPDATE_DT, UPDATE_USERID)
Values ('SYSTEM', 'NA', 'Admin', SYSDATE, 'SYSTEM');
Warning: For Stat 7.0.x you cannot use SD_CD = 'NA', you need to assign a valid SD_CD.
COMMIT;
6. Go to User Maintenance, highlight the SYSTEM user and assign the proper SD (Service Domain).
7. Insert or Copy a new user like SYSTEM (with Admin privilege) and use this user as Stat Admin filling the email address.
