During the installation of WebSphere® ESB, you have the option of using the default schema name and user ID privileges when installing your databases. However, your database design may require separate user ID and schema name privileges. You can review the three provided scenarios to determine when and how to configure different schema name and user ID privileges when installing WebSphere ESB.
If your database design has different properties, you may need multiple user ID and schema name privileges. Provided are three scenarios along with tables to show you how to apply the configuration to achieve your desired design. If your particular design is not in the three provided scenarios, a review of these scenarios should help you implement your particular design.
Scenario 1
Scenario 2
Scenario 3
Schema name | User ID to select, insert, update, and delete schemas |
---|---|
waterCom | waterCom |
waterSYSME | waterSYSME |
waterAPPME | waterAPPME |
waterEventME | waterEventME |
waterESB | waterESB |