E1: DB: Does the JDE Database UserID Require the SysAdmin Role Assignment in EnterpriseOne 9.1?
(Doc ID 1674460.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?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document