Oracle SQLException Error -- Insufficient Privileges

Oracle SQLException Error -- Insufficient Privileges


Scenario:

Inbound EDIFACT ORDER is received and translated into JDEdwards E1 tables via Database Adapter. During SQL insert an error occurs in the Auditor.

Issue:

The userID currently set-up in EXTOL Business Integrator is not allocated the correct permissions.

EXTOL error message:


SQLException:
Message : ORA-01031: insufficient privileges

EXTOL Business Integrato SQLException Error Insufficient Privileges

Resolution:

EXTOL user needs to contact DBA to allow for proper permissions to set-up in the Oracle database.



By: on
A free web counter provided by GoStats.