Contents
- PeopleCode programs
- SQL Scripts
SQL Scripts : Portal
- Determines the portal navigation path for a given component name.
select portal_name, portal_objname, portal_label from psprsmdefn where portal_name = '[REPLACE]' connect by prior portal_prntobjname = portal_objname start with portal_objname = '[REPLACE]' order by level desc
SQL Scripts : Process Scheduler
- Get all processes which are currently in a stage of execution
selecT a.rqstdttm, b.xlatshortname, a.runstatus, a.prcsinstance, a.prcstype, a.prcsname, a.oprid from psprcsrqst a, psxlatitem b where b.fieldname = 'RUNSTATUS' and b.fieldvalue = a.runstatus and a.runstatus in ('4','5','6','7','14','16','18') order by a.rqstdttm
SQL Scripts : Security
- Get all users who are assigned to a given security role
select roleuser from psroleuser where rolename = '[REPLACE]'
- Get all roles that are assigned to a given user
select rolename from psroleuser where roleuser = '[REPLACE]'
- Get all permission lists that are assigned to a given user
select b.classid from psroleuser a, psroleclass b where a.roleuser = '[REPLACE]' and a.rolename = b.rolename order by b.classid;