PeopleSoft Wiki

This page is about PeopleSoft security for users. It contains information about user profiles, roles and permission lists.

Query the roles and permission lists associated with 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