1. Applications Upgrade Guide for Microsoft Windows with Oracle
  2. Removing Database Users for Oracle

Removing Database Users for Oracle

This section lists the database users that must be manually dropped by a DBA for your RDBMS system. This is the list of users that were created by the JD Edwards EnterpriseOne Tools Release 9.2 Installation of the Platform Pack on your Enterprise or Database Server for your JD Edwards EnterpriseOne installation, or from a previous JD Edwards EnterpriseOne installation.

The database users are not automatically removed by the JD Edwards EnterpriseOne uninstallation program. You should have a DBA for your RDBMS manually remove any unused items listed in the table below.

Database Type

Database User

System

Object Librarian

Data Dictionary

SY920

OL920

DD920

SVM920

You should also remove these users of the JD Edwards EnterpriseOne system:

  • jdedba

  • jde

  • applead

  • sysadmin

  • produser

  • devuser

You should also remove the role: jde_role.

Note: For your Oracle installation, the user jde_role may be needed for a previous release.

Production

PD920

PRODDTA

PRODCTL

Note: For your installation, the proddta and prodctl users may be needed for a previous release.

Pristine

PS920

PS920DTA

PS920CTL

Development

DV920

TESTDTA

TESTCTL

Note: For your installation, the testdta and testctl users may be needed for a previous release.

Prototype

PY920

CRPDTA

CRPCTL

Note: For your installation, the crpdta and crpctl users may be needed for a previous release.