#Peoplesoft authorized actions update
#Peoplesoft authorized actions crack

#Peoplesoft authorized actions 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. Group by a.path, a.base_component, a.base_menu, x.authorizedactions, x.displayonly, z.classid Where a.base_component = b.base_component SELECT RTRIM(REVERSE(SYS_CONNECT_BY_PATH(REVERSE(m.PORTAL_LABEL), вЂ > вЂ)), вЂ > вЂ) PATH,Д¬onnect_by_root m.portal_uri_seg2 as base_component,Д¬onnect_by_root m.portal_uri_seg1 as base_menuД¬ONNECT BY PRIOR m.PORTAL_PRNTOBJNAME = m.PORTAL_OBJNAME WHEN 15 THEN вЂADD,UPDATE,DISPLAY,UPDATE/DISPLAY ALL,CORRECTIONвЂ™ WHEN 14 THEN вЂUPDATE,DISPLAY,UPDATE/DISPLAY ALL,CORRECTIONвЂ™ WHEN 13 THEN вЂADD, UPDATE, DISPLAY,UPDATE/DISPLAY ALL,CORRECTIONвЂ™ WHEN 12 THEN вЂUPDATE/DISPLAY ALL,CORRECTIONвЂ™ WHEN 11 THEN вЂADD, UPDATE/DISPLAY ALL, CORRECTIONвЂ™ WHEN 7 THEN вЂADD,UPDATE,DISPLAY,UPDATE/DISPLAY ALLвЂ™ WHEN 6 THEN вЂUPDATE,DISPLAY,UPDATE/DISPLAY ALLвЂ™ Update вЂ“ I tweaked the query to remove the loop that can occur in certain cases, so this should work for all roles now! If you have suggestions for improvement, please let me know! I wanted to recursively find all navigations that a role has access to along with the type of access.

#Peoplesoft authorized actions crack

IвЂ™m sure this query could be tweaked to make it much better, but this was a first crack attempt.