What Permission Lists does this Role Have?

Your rating: None Average: 3 (2 votes)

A query that takes a PeopleSoft role name as a value and returns Permission List(s) associated to that role.

SELECT a.rolename, a.classid AS permission_list
  FROM psroleclass a
 WHERE a.rolename = :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!