Which Roles/Permission Lists/Query Trees grant access to a Record in Query Manager?

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