E1: DB: Does the JDE Database UserID Require the SysAdmin Role Assignment in EnterpriseOne 9.1?
Last updated on MAY 30, 2017
Applies to:JD Edwards EnterpriseOne Tools - Version 9.1 and later
Information in this document applies to any platform.
You are running different EnterpriseOne versions: ERP 8.0, 8.11 SP1 and 9.0. The JDE database ID can be set with db_owner instead of sysadmin. All the versions of E1 are using SQL database. The sysadmin server role is being removed from the user profile JDE and you are assigning the db_owner role for JDE user to all JDE databases.
However, the same setup on E1 9.1 makes the JDE logon fail due to the following error:
In EnterpriseOn 9.1, does the JDE database UserID, for example: JDE - require having the sysadmin role assigned?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms