PS Query Access
Hi,
We are implementing Peoplesoft Campus solution 9.0.
In our Test and Prod server, we are having only our institution related data and not PeopleSoft delivered employees.
We created a PS Query for list of students and their name. when we run the query, there is no output because Query is using some Security Records.
We analysis and found that emplid assigned to PS is not having access
SELECT * FROM PS_SJT_PERSON
SELECT * FROM PS_SJT_OPR_CLS WHERE OPRID = 'PS'
SELECT * FROM PS_SJT_CLASS_ALL WHERE CLASSID = 'HCDPALL'
Please advice how to give security access for the emplid assigned to PS to query all the NAMES and other personal data related records.
0