PeopleSoft Learning

SQL to Identify detailed Security access for a Page or Component.

When you want details about a single page in the component.

select a.menuname,a.barname,a.baritemname,rc.rolename, rd.descr , a.classid, c.classdefndesc,a.Displayonly,ac.pageaccessdescr
from psauthitem a, psclassdefn c, psroleclass rc, psroledefn rd, PSPGEACCESSDESC ac
where a.pnlitemname = :1
and a.classid = c.classid
and a.classid = rc.classid
and rc.rolename = rd.rolename
and a.Authorizedactions = ac.Authorizedactions
Order by rc.rolename;


When you want details about a component.

select a.menuname,a.barname,a.baritemname,rc.rolename, rd.descr , a.classid, c.classdefndesc,a.Displayonly,ac.pageaccessdescr
from psauthitem a, psclassdefn c, psroleclass rc, psroledefn rd, PSPGEACCESSDESC ac
where a.BARITEMNAME = :1
and a.classid = c.classid
and a.classid = rc.classid
and rc.rolename = rd.rolename
and a.Authorizedactions = ac.Authorizedactions
Order by rc.rolename;