This potentially would help teams(specially client team) to build a security matrix to understand it in better way before making any changes or to report for Audit purpose. WHEN AUTHORIZEDACTIONS = 128 THEN ‘No Action Selected’įROM PSAUTHITEM WHERE MENUNAME = ‘MAINTAIN_SECURITY’ –> (Menu Name)ĪND BARITEMNAME = ‘ACL_PURGE_USER_RUN’ –> (Component Name)ĪND PSAUTHITEM WHERE CLASSID = ‘PTPT1100’ –> (Permission List)Ībove query can also be joined with other sub queries to find Permission list assigned to each user profile in turn to find what type of access user has for different components. WHEN AUTHORIZEDACTIONS = 15 THEN ‘Add, Update/Display, Update/Display All, Correction’
WHEN AUTHORIZEDACTIONS = 14 THEN ‘Update/Display, Update/Display All, Correction’ WHEN AUTHORIZEDACTIONS = 13 THEN ‘Add, Update/Display All, Correction’ WHEN AUTHORIZEDACTIONS = 12 THEN ‘Update/Display All, Correction’ WHEN AUTHORIZEDACTIONS = 11 THEN ‘Add, Update/Display, Correction’ WHEN AUTHORIZEDACTIONS = 10 THEN ‘Update/Display, Correction’ WHEN AUTHORIZEDACTIONS = 9 THEN ‘Add, Correction’ WHEN AUTHORIZEDACTIONS = 8 THEN ‘Correction’ WHEN AUTHORIZEDACTIONS = 7 THEN ‘Add, Update/Display, Update/Display All’ WHEN AUTHORIZEDACTIONS = 6 THEN ‘Update/Display, Update/Display All’ WHEN AUTHORIZEDACTIONS = 5 THEN ‘Add, Update/Display All’ WHEN AUTHORIZEDACTIONS = 4 THEN ‘Update/Display All’ WHEN AUTHORIZEDACTIONS = 3 THEN ‘Add,Update/Display’ WHEN AUTHORIZEDACTIONS = 2 THEN ‘Update/Display’ (CASE WHEN AUTHORIZEDACTIONS = 1 THEN ‘Add’ If you haven’t heard what has been released as part of Update.
PEOPLESOFT AUTHORIZED ACTIONS UPDATE
Customers can selectively adopt new features and enhancements using the PeopleSoft Update Manager. (CASE WHEN DISPLAYONLY = 0 THEN ‘Editable’ ELSE ‘Read Only’ END) PAGE_VIEW, PeopleSoft FSCM Update Image 39 has been generally available since 9th Mar 2021 and it contains many important new functional enhancements. SELECT CLASSID PERMISSION_LIST, MENUNAME, PNLITEMNAME, At times Implementation/Support Team faces lots of difficulty to understand/figure out security settings when starting a new project.Īlso, most of the time clients face equal challenges to answer the security related queries from Implementation/Support Team (unless have good in house PeopleSoft Support Team)Ĭonsidering these challenges and hiccups by both the teams, below is an attempt made to bridge the gap for some basic Security related queries.įollowing is a query which would help both teams to list down the type of component access set for each user.įor example, if it needed to find out what type of access is assigned to a component (Add, Update/Display,Correction etc), below query can be useful as it would display details when Menu Name/Component Name/Permission List name passed as input parameter For all PeopleSoft Projects, setting up Security is one of the sensitivity and tricky part of project.
0 kommentar(er)
