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月13日星期一
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'
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'
订阅:
博文 (Atom)