My Oracle Support Banner

E1: DB: How to Revoke Public Access for the JDE Database for EnterpriseOne 8.12, 9.0 , 9.1 and 9.2 (Doc ID 755714.1)

Last updated on MAY 04, 2022

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.97 and Prior and later
Information in this document applies to any platform.


JDEdwards EnterpriseOne delivers their databases providing full access to public.  Public permission acts as a default role granted to every database user.

How to grant access to each database table to one or more database roles while revoking access to public?


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
 For EnterpriseOne 8.12
 For EnterpriseOne 9.0/9.1
 For EnterpriseOne 9.2

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