Which users can see which reports in the Query Manager Query Viewer?
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.
Now what I need is to generate a report, from the database, of which users can see which reports in the Query Viewer of the Query Manager.