Chat now with support
Chat with Support

Stat 6.3 - System Administration Guide

Overview of Stat Administration Administrative Utilities Stat Security General Maintenance Tables
System Maintenance Service Domain Maintenance Department Maintenance Issue Tracking Maintenance Country Maintenance Customer Maintenance Object Type Maintenance PeopleSoft Environment Connection Maintenance Pre/Post Migration Steps Parameters Oracle Applications Configuration Oracle Applications Connection Maintenance Generic Application Connection Maintenance Schema Object Parameters Maintenance Data Object Maintenance PeopleSoft Search Configurations Stat Report Definition Maintenance Version Control Management Connection Maintenance
Service Domain-Specific Maintenance Configuring the Stat Central Agent Email Configuration Object Security Appendix: Sample Service Domain Configuration Appendix: User Class Rights Appendix: Creating a Staging Database Appendix: Database Tuning Appendix: Oracle Applications File Type Directory Appendix: Ports and Firewalls Appendix: REST Web Services API Appendix: SOAP-Based Web Services API Appendix: Troubleshooting Chart Appendix: stat.conf Configuration Appendix: Custom Report Files

Changing the STATLOGIN Password

The initial STATLOGIN password is delivered as part of the installation scripts and is used to define the STATLOGIN user on the database. The system administrator can modify the STATLOGIN password on the database (25 characters maximum) as dictated by internal business processes and update that password in the INI Editor. The password is encrypted and stored in the stat.ini file.

* 
IMPORTANT: Changing the STATLOGIN password should not be confused with changing the Stat database password, which is documented in the section Changing the Database Password .

There are two options for modifying the password. In either scenario the administrator or DBA needs to first modify the STATLOGIN user password on the database. Then they can either:

1
Distribute the unencrypted password and have each user update their own stat.ini file with the password.
Or
2
The Administrator changes the password in the INI Editor and then distributes the encrypted password to the users to place into their editini.exe program.
To modify the password using the non-encrypted password:
1
Click Change Password.
2
Enter the New Password and the confirmation of the New Password and click OK.
The new encrypted password is displayed in the Encrypted Login Password field.
3
Click in the field and right click to copy the encrypted password if it needs to be distributed.
4
Click on any other field and click Test Connection to test the password.
5
If the password for STAT database userid is invalid, you will be prompted to enter a new STAT userid password.
6
Save your changes.
To modify the encrypted password:
* 
NOTE: This assumes that someone has already followed the procedure above and has sent you an encrypted password.
1
Replace the existing Encrypted Login Password value with the new value.
2
Click on any other field and then click Test Connection to test the password.
3
Save your changes.

Testing Connections

After defining a database record, you can make sure that you have entered all the information correctly by selecting the record and clicking Test Connection. This makes Stat establish a connection to the database. If successful, Stat immediately disconnects from the database and displays a “Connection Successful” message box. If Stat is unable to connect, it displays a message box stating the cause of the failure, for example, “invalid username/password. logon denied.”

Editing Records

To edit a database profile record, select the database whose profile you want to edit and specify different values as needed in the appropriate fields.

Deleting Records

To delete record, select the record. Then select Edit | Delete Record.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating