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
No Comments