How Data Source Security is Applied in an Install Versus Upgrade

For a new EnterpriseOne applications installation, all tables in the data source are secured with the roles specified in the Platform Pack Installer.

For an EnterpriseOne upgrade, only tables created by the Platform Pack are secured with the roles specified during the install. Existing business data and control tables are not secured by the install. In the business data and control tables data source, set up roles for a database administrator and database user. Add these same roles to the Grant Data Source Privileges (P986117) application in EnterpriseOne.