For my user ]and other users with problems], my row security permission list was UBCSDP000000.
#Peoplesoft query security update#
I started by breaking out all the FROM items and noticed that I was not seeing any results returned from PS_PERALL_SEC_QRY.Īfter a lot of digging down, I realized that I needed to update the Row Security permission list.
The “mjb14_2t” and oprclass were valued entered in that were specific to my user running the query. Sysadm.PS_ADM_APPL_PLAN E, (sysadm.PS_PERSONAL_DATA D INNER JOIN sysadm.PS_PERALL_SEC_QRY D1 ON (D.EMPLID = D1.EMPLID AND D1.OPRID = ‘mjb14_2t’ ) (sysadm.PS_ADM_APPL_PROG C INNER JOIN sysadm.PS_ADM_MAINT_SCTY C1 ON (C.EMPLID = C1.EMPLID AND C.ACAD_CAREER = C1.ACAD_CAREER AND C.STDNT_CAR_NBR = C1.STDNT_CAR_NBR AND C.ADM_APPL_NBR = C1.ADM_APPL_NBR AND C.APPL_PROG_NBR = C1.APPL_PROG_NBR AND C1.OPRCLASS = ‘UBCSPPPS00’ AND C1.OPRID = ‘mjb14_2t’ )), (sysadm.PS_ADM_APPL_DATA B INNER JOIN sysadm.PS_ADM_APPL_SCTY B1 ON (B.EMPLID = B1.EMPLID AND B.ACAD_CAREER = B1.ACAD_CAREER AND B.ADM_APPL_NBR = B1.ADM_APPL_NBR AND B1.OPRCLASS = ‘UBCSPPPS00’ AND B1.OPRID = ‘mjb14_2t’ )), (A.EMPLID = A1.EMPLID AND A.ACAD_CAREER = A1.ACAD_CAREER AND A.ADM_APPL_NBR = A1.ADM_APPL_NBR AND A.INSTITUTION = A1.INSTITUTION AND A1.OPRCLASS = ‘UBCSPPPS00’ AND A1.OPRID = ‘mjb14_2t’ )), SELECT A.EMPLID, A.ACAD_CAREER, A.STDNT_CAR_NBR, A.ADM_APPL_NBR, A.INSTITUTIONįROM (sysadm.PS_SCC_PS_ADMA_BND A INNER JOIN sysadm.PS_ADM_APPL_SCTY A1 ON This was the selection portion of the query: They claimed that there should be 1000’s of records returned.
I had a few users trying to execute a query that was returning no results.
0 kommentar(er)
