SQL to identify which USER, ROLE and PERMISSION LIST has access to a particular Component Interface

      SELECT DISTINCT R.ROLEUSER AS USER_IDS, C.ROLENAME as ROLE, P.CLASSID AS       PERMISSION_LIST

        FROM PSROLEUSER R, PSROLECLASS C, PSAUTHBUSCOMP P

       WHERE R.ROLENAME = C.ROLENAME

         AND P.CLASSID  = C.CLASSID

         AND P.BCNAME   = 'XXXX_CI'

       ORDER BY 1,2,3;