Which Users have access to a Page


Find out which users (and from what permission lists) have access to a particular page:

select distinct OPRID, OPRCLASS
from PSOPRCLS
where OPRCLASS in (
    select distinct CLASSID
    from sysadm.PSAUTHITEM
    where PNLITEMNAME = '{PAGENAME}'
);

Revision #1
Created Mon, Aug 5, 2019 7:59 PM by PeopleSoft Wiki
Updated Mon, Aug 5, 2019 7:59 PM by PeopleSoft Wiki