显示标签为“Security”的博文。显示所有博文
显示标签为“Security”的博文。显示所有博文

2015年4月13日星期一

How to close the Connection & Sys Info function

PeopleSoft provides a hotkey option (CTRL+J) to enable users and system administrators to view such system information for orientation and troubleshooting purposes. But the information displayed may not be suitable for end users. How to turned it off? You can navigate to PeopleTools > Web Profile > Web Profile Configuration, go to page Debugging, uncheck the  


2015年4月12日星期日

Oprid to page security

Oprid to page security

select rolluser.oprid oprid,
       rolluser.rolename rolename,
       roledefn.roletype roletype,
       roledefn.descr roledes,
       roledefn.rolestatus rolestatus,
       rlclass.classid permissionlist,
       classdefn.classdefndesc listdesc,
       menudefn.menuname menuname,
       menudefn.menulabel menulabel,
       menudefn.descr descr,
       m_c_p.pnlgrpname component,
       component.pnlname page,
       component.itemlabel pagename
  from psroleuser_vw rolluser,
       psroledefn    roledefn,
       psroleclass   rlclass,
       psclassdefn   classdefn,
       ps_psaclmenu_vw2 clmenu,
       psmenudefn menudefn,
       ps_aclcomponent_v2 m_c_p,
       pspnlgroup component
 where rolluser.rolename = roledefn.rolename
   and rolluser.rolename = rlclass.rolename
   and rlclass.classid = classdefn.classid
   and clmenu.classid = rlclass.classid
   and clmenu.menuname = menudefn.menuname
   and component.pnlgrpname = m_c_p.pnlgrpname
   and oprid = 'OPRID'
   and classdefn.classid = 'PERMISSIONLIST'