Get roles and permissions for a particular user


The following query will return the roles and permission lists that a particular user belongs to. Replace the OPRID value in the line RU.ROLEUSER = 'OPRID' with the operator ID of the user you are interested in (e.g. PS).

select
    RU.ROLEUSER as OPRID,
    RU.ROLENAME as ROLE,
    RC.CLASSID as PERMISSION_LIST
from
    PSROLEUSER RU inner join PSROLECLASS RC
    on RU.ROLENAME = RC.ROLENAME
where
    RU.ROLEUSER = 'OPRID'
order by ROLE, PERMISSION_LIST

Revision #1
Created Tue, Jul 23, 2019 12:37 PM by PeopleSoft Wiki
Updated Tue, Jul 23, 2019 12:38 PM by PeopleSoft Wiki