Thursday, July 30, 2015

SQL to get the roles assigned to a permission list

SELECT B.ROLENAME, B.CLASSID AS PERMISSION_LIST
      FROM PSCLASSDEFN A, PSROLECLASS B
     WHERE A.CLASSID = B.CLASSID AND A.CLASSID = 'PTPT1200'
     ORDER BY 1,2;

No comments:

Post a Comment