SELECT DISTINCT 
C.ROLENAME,
A.CLASSID, 
A.PRCSGRP,
B.PRCSTYPE 
FROM PSAUTHPRCS A, 
     PS_PRCSDEFNGRP B,
     PSROLECLASS C 
WHERE A.PRCSGRP = B.PRCSGRP
  AND A.CLASSID = C.CLASSID
  AND B.PRCSNAME = 'DDDAUDIT'   -> Replace Process Definition Name Here
No comments:
Post a Comment