› › 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
load('http://www.extol.com/extolnews.rss'); $feed = array(); foreach ($rss->getElementsByTagName('item') as $node) { $item = array ( 'title' => $node->getElementsByTagName('title')->item(0)->nodeValue, 'desc' => $node->getElementsByTagName('description')->item(0)->nodeValue, 'link' => $node->getElementsByTagName('link')->item(0)->nodeValue, 'date' => $node->getElementsByTagName('pubDate')->item(0)->nodeValue, ); array_push($feed, $item); } $limit = 4; echo ' A free web counter provided by GoStats.