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

Document ID : KB000016497
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

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

Question:

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

I need a full list.

Answer:

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