What permissions are needed for the database user id for the Peoplesoft Plugin?

book

Article ID: 16497

calendar_today

Updated On:

Products

CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) CA Workload Automation Agent

Issue/Introduction

What permissions are needed for the database user id for the Peoplesoft Plugin?



What permissions are needed for the database user id for the Peoplesoft Plugin?

I need a full list.

Environment

Release: ATSYHA99000-11.3.6-Workload Automation AE-High Availability Option
Component:

Resolution

The following is required for the database user id for Peoplesoft Plugin:

 

GRANT SELECT ON SYSADM.PSAUTHPRCS

GRANT SELECT ON SYSADM.PSOPRCLS

GRANT SELECT ON SYSADM.PS_PRCSDEFN

GRANT SELECT ON SYSADM.PS_PRCSDEFNGRP

GRANT SELECT ON SYSADM.PS_PRCSRUNCNTLDTL

GRANT SELECT ON SYSADM.PS_PRCSSYSTEM

GRANT SELECT ON SYSADM.PS_PRCSTYPEDEFN

GRANT SELECT ON SYSADM.PS_SERVERDEFN

GRANT INSERT, SELECT, UPDATE ON SYSADM.PSPRCSPARMS

GRANT INSERT, SELECT, UPDATE ON SYSADM.PSPRCSQUE

GRANT INSERT, SELECT, UPDATE ON SYSADM.PSPRCSRQST

GRANT INSERT, SELECT, UPDATE ON SYSADM.PSPRCSRQSTTEXT

GRANT INSERT, SELECT, UPDATE ON SYSADM.PS_AEREQUESTTBL

GRANT INSERT, SELECT, UPDATE ON SYSADM.PS_CDM_AUTH

GRANT INSERT, SELECT, UPDATE ON SYSADM.PS_CDM_LIST

GRANT INSERT, SELECT, UPDATE ON SYSADM.PS_PRCSRQSTDIST

GRANT INSERT, SELECT, UPDATE ON SYSADM.PS_PRCSRUNCNTL

GRANT INSERT, SELECT, UPDATE ON SYSADM.PS_PRCSSEQUENCE

GRANT INSERT, SELECT, UPDATE ON SYSADM.PS_RUN_CNTLLDAP