Roles Assigned to a Permission List

Your rating: None Average: 4 (3 votes)

A query to help you identify Roles that are assigned to a specific permission list.

SELECT b.rolename, b.classid AS permission_list
  FROM psclassdefn a, psroleclass b
 WHERE a.classid = b.classid AND a.classid = :permissionlist;

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!