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.

Goal

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?
 

Solution

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