SELECT DISTINCT
C.ROLENAME,
B.CLASSID as Permission_List,
A.TREE_NAME
FROM PSTREENODE A,
PS_SCRTY_ACC_GRP B,
PSROLECLASS C
WHERE A.TREE_NODE_TYPE='R'
AND A.TREE_NAME = B.TREE_NAME
AND B.CLASSID = C.CLASSID
AND B.ACCESSIBLE = 'Y'
AND A.PARENT_NODE_NAME = B.ACCESS_GROUP
AND A.TREE_NODE like '%JOB%' --> Replace Record Name Here
No comments:
Post a Comment