My Oracle Support Banner

E1: DB: Does the JDE Database UserID Require the SysAdmin Role Assignment in EnterpriseOne 9.1? (Doc ID 1674460.1)

Last updated on FEBRUARY 05, 2019

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.