User IDs assigned to a Permission List

Your rating: None Average: 3.7 (3 votes)

A query to list all user IDs that are assigned to a specific permission list.

SELECT   c.roleuser AS USER_IDs
    FROM psclassdefn a, psroleclass b, psroleuser c
   WHERE a.classid = b.classid
     AND b.rolename = c.rolename
     AND a.classid = :permissionlist
GROUP BY c.roleuser;

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!