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.
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