OSI DB user grants

Document ID : KB000089295
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
OSI DB user grants
Resolution:

Symptoms

An error message is generated when an OSI job is submitted.

Error Message:

ORA-01932: ADMIN option not granted for role 'BATCHSRV'

Cause

The correct grants have not been applied.

Solution

Applying the proper grants to the OSI user should keep that error message from occurring.

List of grants needed by the OSI user:

grant select, insert, update on osibank.que to awbatch;
 grant select, insert on osibank.queappl to awbatch;
 grant select, insert on osibank.queapplhist to awbatch;
 grant select, insert on osibank.queapplparam to awbatch;
 grant select on osibank.queapplerror to awbatch;
 grant select, insert on osibank.queapplacctcycle to awbatch;
 grant select on osibank.acctcycleappl to awbatch;
 grant select on osibank.bankoption to awbatch;
 grant select on osibank.appl to awbatch;
 grant select on osibank.parameter to awbatch;
 grant select on osibank.applparameter to awbatch;
 grant select on osibank.quenbr_pk to awbatch;
 grant select on osibank.extfile to awbatch;
 grant batchsrv to awbatch;