SAP Knowledge Base Article - Preview

2638481 - Data Services jobs are failing when Oracle public access is revoked

Symptom

  • Data Services Jobs are executing without error while Oracle Package permissions are public
  • When public access is revoked, jobs fail
  • PLS-00201: identifier 'DBMS_SQL' must be declared
  • PL/SQL: Statement ignored
  • What is the required permission level of Oracle products for SAP products?


Read more...

Environment

SAP Data Services 4.x

Product

SAP Data Services 4.2

Keywords

DBMS_LOB, DBMS_JOB,  DBMS_OBFUSCATION_TOOLKIT, revoke execute

Extra requirements for Oracle
, KBA , EIM-DS-EXE , Job Execution , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.