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 SEPTEMBER 22, 2024

Applies to:

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

Goal

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?

Solution

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
Goal
Solution
 For EnterpriseOne 8.12
 For EnterpriseOne 9.0/9.1
 For EnterpriseOne 9.2 / Mandatory Privileges Required
References

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