myPeopleSoft

PeopleSoft Community Network

Peoplesoft Security

SQL to find data Security

-- WHICH USER HAS THE PERMISSION TO SEE THE EMPLOYEE

SELECT DISTINCT A.CLASSID ,A.OPRID, C.EMPLID, B.SCRTY_KEY1,

B.SCRTY_KEY2, B.SCRTY_KEY3,C.SCRTY_KEY1, C.SCRTY_KEY2, C.SCRTY_KEY3 FROM

PS_SJT_OPR_CLS A, PS_SJT_CLASS_ALL B, PS_SJT_PERSON C, PS_JOB D

WHERE D.EMPLID = '99999'

AND D.EMPLID = C.EMPLID

AND A.CLASSID = B.CLASSID

AND B.SCRTY_TYPE_CD = C.SCRTY_TYPE_CD

AND B.SCRTY_KEY1 = C.SCRTY_KEY1

AND B.SCRTY_KEY2 = C.SCRTY_KEY2

AND B.SCRTY_KEY3 = C.SCRTY_KEY3

--WHICH OPERATOR HAS THE PERMISSION TO SEE THE JOB OPENING

SELECT DISTINCT A.CLASSID,A.OPRID, B.SCRTY_KEY1,

B.SCRTY_KEY2, B.SCRTY_KEY3,C.SCRTY_KEY1, C.SCRTY_KEY2,C.SCRTY_KEY3 FROM

PS_SJT_OPR_CLS A, PS_SJT_CLASS_ALL B, PS_HRS_SJT_JO C,PS_HRS_JOB_OPENING D

WHERE D.HRS_JOB_OPENING_ID= '12345'

AND A.CLASSID = B.CLASSID

AND B.SCRTY_TYPE_CD = C.SCRTY_TYPE_CD

AND B.SCRTY_KEY1 = C.SCRTY_KEY1

AND B.SCRTY_KEY2 = C.SCRTY_KEY2

AND B.SCRTY_KEY3 = C.SCRTY_KEY3

AND D.HRS_JOB_OPENING_ID = C.HRS_JOB_OPENING_ID

Web Libraries

Web Libraries assigned to a specific OPRID through their Permission Lists.'

SELECT OPRID, CLASSID, MENUNAME FROM PSOPRCLS A, PSAUTHITEM B WHERE A.OPRCLASS = B.CLASSID AND B. MENUNAME like 'WEBLIB%'

Web Libraries assigned to specific Permission List.'

Read Further: http://peoplesoft-hcm-nap-ben.blogspot.com/p/peoplesoft-security.html

0 members like this