My Oracle Support Banner

E1: CFR11: Unable to Enable Auditing On Any / New Tables. Error: OCI0000178 - Unable to execute - GRANT ALTER (Doc ID 2591253.1)

Last updated on SEPTEMBER 21, 2022

Applies to:

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

Symptoms

Unable to enable auditing on new tables now. Previously this feature was working fine and auditing was enabled successfully on multiple tables. Auditing is still working fine for these tables.

However, users are not able to enable auditing for more tables now. They have already given the required rights to the owners of the auditing table.

The below privileges were assigned to the owners of the audit tables F9500003, F9500004, and F9500006 (for example PRODDTA, DD812).

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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