OSI DB user grants

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

OSI DB user grants

Environment

Release: AAMOS499000-8.0-Automic Applications Manager-OS400 Agent
Component:

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;