Peoplesoft Guide: SQL - Roles Assigned to Permission List

SQL - Roles Assigned to Permission List

Posted by Admin at 5:55 AM Labels: PS Security, SQL

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

You can review more about this document by using the following Google Search