WebAuthorized Actions in PSAUTHITEM table may have several values. All these values represent the permissions that are allowed on a component/page by the particular … WebFROM PSAUTHITEM A , PSROLECLASS B , PSROLEUSER C WHERE A.CLASSID = B.CLASSID AND B.ROLENAME = C.ROLENAME AND A.MENUNAME = 'QUERY' ORDER BY 1,2; *****--SQL to check access of Performance Monitor PPMI Access on PeopleTools tab in PL. SELECT * FROM PSAUTHITEM WHERE CLASSID = 'ALLPAGES' AND MENUNAME = 'PERFMONPPMI';

PeopleTools Access PeopleSoft Wiki

WebAccess the Permission Lists page (select PeopleTools, Security, Permissions and Roles, Roles and click the Permission Lists tab). Roles - Permission Lists page To add new permission lists to a role, add more rows. Remember that a user's access is determined by the sum of all the permission lists applied to each role to which the user belongs. WebFeb 17, 2006 · Basically take the permission list ALLPAGES and enable the display-only flag for all pages. I am trying to do this using SQL, but in tools version 8.45 changing the ""displayonly"" field from 0 to 1 in PSAUTHITEM does not do the trick. I believe that used to work in older tools versions. I do not believe there is anything going on with ... cornerstone family health port jervis ny

Transfer PeopleSoft Wiki

WebIn addition, the PeopleSoft Administrator role gives full access to menus and pages in the PSAUTHITEM table. The PeopleSoft Administrator role cannot be viewed, edited, … WebJun 16, 2024 · *Script found in PeopleBooks: Administration Tools > Data Management >Ensuring Data Integrity > Running SYSAUDIT > SEC-28 Resolution WebJan 20, 2011 · Try the psroleclass and psauthitem table. PSAUTHITEM gives you info about menus, components and pages a user is authorized to access. PAROLECLASS gives you info about role and permission lists assign to that role. flag Report Was this post helpful? thumb_up thumb_down OP previous_toolbox_user pimiento Jan 20th, 2011 at 12:51 PM cornerstone family health midland tx