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
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.'
SELECT * FROM PSAUTHWEBLIBVW WHERE CLASSID = 'ALLPAGES'
Valid Web Libraries that are in database'
SELECT * FROM PSWEBLIB_PRMTVW
Certain new Web libraries have been introduced on 8.46 for enabling folder navigation. Make sure that all the user have FULL access to the following Web libraries:
WEBLIB_PTPP_SC
WEBLIB_PTPPB
WEBLIB_PTPPB1
WEBLIB_EOPP_SC
WEBLIB_PORTAL
WEBLIB_PT_NAV
Delievered Permission Lists and its WebLibraries
PAPP0000
WEBLIB_EOPP_SC
WEBLIB_PORTALPTPT1000
WEBLIB_PTPP_SC
WEBLIB_PTPPB
WEBLIB_PTPPB1
WEBLIB_PTPPB
WEBLIB_PTPPB1
WEBLIB_PORTAL
WEBLIB_PT_NAV
Row Security Permission List
When data security given through the component Security by Department tree for a permission list and such Permission list is mapped to the user in the User profile page, then such Permission list is defined as Row Security Permission list. Refresh SJT_CLASS_ALL process has to be executed when ever, There is a change in Dept-security Tree. There is a data change for the permission list in the component Security by Department tree . Recuritment : Define the row security permission list in the page setup HRMS, security, core row level security, recruiting row level security.
Site id also requires row security permission list. which would control the job opening listing in the site.
When data security given through the component Security by Department tree for a permission list and such Permission list is mapped to the user in the User profile page, then such Permission list is defined as Row Security Permission list. Refresh SJT_CLASS_ALL process has to be executed when ever, There is a change in Dept-security Tree. There is a data change for the permission list in the component Security by Department tree . Recuritment : Define the row security permission list in the page setup HRMS, security, core row level security, recruiting row level security.
Site id also requires row security permission list. which would control the job opening listing in the site.
Primary Permission List:
1. Defined in the user profile general page.
2. Page defaults are determined by it Like, set id, BU etc.,
Setup hrms, foundation table, organization, Org Defaults by Permission Lst
3. local functionality (country ) display is controlled by primary permission list
Defining Local (country) Functionality
1. In the setup hrms, install, installation table - > go to the table country specific and click on the link installed hr countries.
2. Only the selected countries local functionality will be available for any user, however out of selected countries which countries local functionality available to the user is specified in-> setup HRMS, security, component and page security , setup global security
3.If you want restrict certain components not to use the country local functionality , then click on the excluded component and give the component name and save
1. Defined in the user profile general page.
2. Page defaults are determined by it Like, set id, BU etc.,
Setup hrms, foundation table, organization, Org Defaults by Permission Lst
3. local functionality (country ) display is controlled by primary permission list
Defining Local (country) Functionality
1. In the setup hrms, install, installation table - > go to the table country specific and click on the link installed hr countries.
2. Only the selected countries local functionality will be available for any user, however out of selected countries which countries local functionality available to the user is specified in-> setup HRMS, security, component and page security , setup global security
3.If you want restrict certain components not to use the country local functionality , then click on the excluded component and give the component name and save
