Revoke PUBLIC Access to Installed EnterpriseOne Database Tables

JD Edwards EnterpriseOne Applications release 9.1 and prior include database Platform Packs that install EnterpriseOne tables with PUBLIC level access. PUBLIC acts as a default role granted to every database user. Oracle provides platform specific tools to revoke PUBLIC access from EnterpriseOne database tables. Implementing the platform specific tools enables you to ultimately grant access for each database table to one or more database roles while revoking access to PUBLIC. The database roles will be associated to each EnterpriseOne system (proxy) user as deemed appropriate. This ensures that the database tables are accessible by only database users associated to a particular database role.

The following sections provide links for the platform-specific tools that you can use to revoke PUBLIC access from EnterpriseOne tables for the supported databases: Oracle, Microsoft SQL Server, and IBM databases.