Roles Assigned to a Component

Your rating: None Average: 3.5 (2 votes)

The SQL will pull Roles assigned to a specific component.

 SELECT B.MENUNAME,
  B.BARITEMNAME   ,
  A.ROLENAME
   FROM PSROLECLASS A ,
  PSAUTHITEM B
  WHERE A.CLASSID = B.CLASSID
AND B.BARITEMNAME = :1 -- COMPONENT NAME
GROUP BY B.MENUNAME,
  B.BARITEMNAME    ,
  A.ROLENAME
ORDER BY B.MENUNAME,
  A.ROLENAME;

Please try to help out with unanswered topics on the forum. Chances are you have had the same issue/question some time in your IT career!