Roles, Permission Lists & Components

The following SQL identifies which roles/permission lists a user has to access a given component.

select RUSR.OPRID,
       RUSR.ROLENAME,
       RCL.CLASSID,
       MNU.MENUNAME,
       CMP.PNLGRPNAME
  from PSROLEUSER_VW RUSR,
       PSROLECLASS RCL,
       PS_PSACLMENU_VW2 MNU,
       PS_ACLCOMPONENT_V2 CMP
 where RUSR.ROLENAME  = RCL.ROLENAME
   and RUSR.OPRID     = 'oprid'
   and RCL.CLASSID    = MNU.CLASSID
   and MNU.MENUNAME   = CMP.MENUNAME
   and CMP.PNLGRPNAME = 'component'
 order by MNU.CLASSID

SQL to find out which roles have a particular permission list.

select distinct RCL.ROLENAME,
                RCL.CLASSID
           from PSROLEUSER_VW  RUSR,
                PSROLECLASS  RCL
          where RCL.CLASSID = 'TYALLPLS'
       order by RCL.ROLENAME

SQL to list users assigned to a particualr role.

select *
  from PSROLEUSER_VW RUSR
 where RUSR.ROLENAME = 'Rolename'