Database User Management

Oracle Food and Beverage mandates that users create a different, strong password for the pre-defined Simphony user within the EMC’s Enterprise Level, Personnel, and Employees module. The password must be at least 8 characters long and include letters and numbers. Simphony’s installation wizard prompts for a unique System Administrator username and password to begin the installation. The System Administrator is used to log into the Oracle Database. Simphony’s installation wizard also prompts for the creation of a System Database User. Simphony’s uses the database user credentials to access the database during communication with services. Oracle Food and Beverage mandates using a unique username and a complex password consisting of more than eight characters including alphanumeric and special characters.

Security Note

Database authentication credentials are stored in the configuration file (DBSettings.xml) on the Simphony application server, protected by Microsoft Windows Server file permissions. No applications, except for the application server, need access to the database directly. After the initial authentication, the application server performs a check of the authorization for the given user to perform the requested action.