Changing Database Passwords

Application Server

Crypt is a database credential management tool for the Simphony application. Crypt allows you to manage database users and their passwords, which are used to connect to the databases required for the proper operation of Simphony. For privileged users, the utility helps you:

• Test database connections

• Change database passwords

• Encrypt database passwords

Note:

The Crypt utility updates new passwords for the Simphony configuration files, but does not change passwords on the actual database platform. If you do not change the passwords for the database platform or if you enter incorrect passwords while using the Crypt utility, the database connection to the Simphony application fails.

To ensure strict access control of the Simphony application, always assign unique usernames and complex passwords to each account (even if they won’t be used), and then disable or do not use the accounts. Oracle Food and Beverage mandates applying these guidelines to not only Simphony passwords but to any applicable operating system passwords as well. Furthermore, Oracle Food and Beverage advises users to control access, via unique usernames and complex passwords, to any PCs, servers, and databases.

See the Oracle MICROS Simphony Post-Installation or Upgrade Guide, specifically the Updating Property Administrator and Database Logon Credentials section for more information about configuring strong passwords.

To access the Crypt utility:

1. Sign on to the Simphony application server.
2. Access the [Drive letter]:\Micros\Simphony\Tools\ folder and double-click the Crypt executable. This utility edits the Simphony Database authentication credential stores in the configuration file (DBSettings.xml).

   Figure 2-15 Crypt Database Password Encryption Tool

   
   
   
3. To change database passwords using the Crypt utility:
   1. Select the database.
   2. Enter your username in the DB Username field.
   3. Enter a new password in the DB Password field.
   4. Confirm the password in the Re-enter Password field.
   5. Enter the Simphony application server name in the Server Name field.
   6. Click the Encrypt Password button.
   7. Click the Test Connection button to verify that the Simphony application DB Passwords match the database passwords.
4. To encrypt database passwords using the Crypt utility:
   1. Select the database.
   2. Click the Encrypt Passwords(s) button.
   3. Click the Test Connection button.
5. To test database connections using the Crypt utility:
   1. To test the currently selected database settings, select the Test current DB Settings check box and then click the Text Connection button.
   2. To test other database connections, select the database from the DB Type/Name drop-down list and then click the Text Connection button.

Workstation

If you did not configure unique usernames and complex passwords for the workstation database as part of the pre-installation process, you must do it now. It is paramount to maintain workstation database access control. You must assign these unique usernames and complex passwords in the Simphony EMC.

For more information on how to configure workstation database passwords, refer to the Configuring Workstation Database Passwords in the EMC topic.