Scribd
Upload
6 views1 page

Access Roles for Query Manager Records

This SQL query identifies the roles, permission lists, and query trees that grant access to a specific record in Query Manager. It joins data from three tables - PSTREENODE, PS_SCRTY_ACC_GRP, and PSROLECLASS - to retrieve the role name, permission list ID, and query tree name where the record name is referenced and access is granted.

Uploaded by

kumarnuj
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
6 views1 page

Access Roles for Query Manager Records

This SQL query identifies the roles, permission lists, and query trees that grant access to a specific record in Query Manager. It joins data from three tables - PSTREENODE, PS_SCRTY_ACC_GRP, and PSROLECLASS - to retrieve the role name, permission list ID, and query tree name where the record name is referenced and access is granted.

Uploaded by

kumarnuj
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

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

SELECT DISTINCT [Link], [Link] 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 [Link] = [Link] AND [Link] = 'Y' AND A.PARENT_NODE_NAME = B.ACCESS_GROUP AND A.TREE_NODE like '%JOB%' --> Replace Record Name Here

You might also like