Which users can see which reports in the Query Manager Query Viewer?
I have not find the table(s) that relate the access groups (located in PSTREENODE, TREE_NAME, PARENT_NODE_NAME) to the permission lists (which are assigned a role):
I understand that for a user to be able to see a certain report in the Query Manager Query Viewer, it depends on the tables used in the report, the access groups must be added to the permission lists that are assigned to the role assigned to them assign to the user. This is how I have worked on assigning permissions within the PeopleSoft Campus application:
In the Permissions lists I add Access Group so the users can see certain reports that are in the Query Manager.