User Security Queries for PeopleSoft

Post Level         : Advanced/Good to Know

Target Readers : Beginners to Experts

1. Users for a particular component.

Select distinct UR.ROLEUSER, PC.MENUNAME, PC.BARNAME,
PC.BARITEMNAME, MI.PNLGRPNAME, PC.PNLITEMNAME
from PSROLEUSER UR, PSROLECLASS RP, PSAUTHITEM PC,
PSMENUITEM MI
where UR.ROLENAME = RP.ROLENAME
and RP.CLASSID = PC.CLASSID
and PC.MENUNAME = MI.MENUNAME
and PC.BARNAME = MI.BARNAME
and PC.BARITEMNAME = MI.ITEMNAME 
and MI.PNLGRPNAME = '<Component Name>'
order by UR.ROLEUSER, PC.MENUNAME, PC.BARNAME,
PC.BARITEMNAME, PC.PNLITEMNAME;

Sample Output: