1887288 - Data Services database user requires create and drop table permissions on a source datastore

When running a job in Data Services you may recieve a database permissions error from your source datastore similar to the following:

*replace <database> with your database name
**replace <datastore> with your datastore name

• SQLCODE = -204, ERROR:
  <database>.DS_686415880_<datastore> SQLERRP = DSNXOFE SQL PROCEDURE DETECTING ERROR SQLERRD = 200 0 0 1 0 0 SQL DIAGNOSTIC INFORMATION
  TABLE ds_686415880_<datastore>(C1 VARCHAR(10) NOT NULL)
• The following special registers have been set: CLIENT_APPLNAME:
  AL_ENGINE
  DS_99686832_<datastore> in QGPL type *FILE not found. Commitment control operation not currently allowed. (R C)

Note: the error will be different depending on your job design, database type and connection method.

ds_*, work table, temp table , KBA , EIM-DS-EXE , Job Execution , Problem