The Projection Grant Screen allows you to individually report which Permission Sets a single Projection has been granted to. However, I have a need to ringfence numerous Projections and would like to be able to report on X number of Projections at once and get a listing of the Permission sets each Projection is granted to (ideally would be usefully to exclude looking into Permission sets that I know are not relevant). I can see this as being a frequent admin task to ensure the integrity of the permission sets\system. This will also provide evidence of active management in the area to our auditors. Does anyone know of a suitable report/solution for this requirement.
Solved
Reporting on Multiple Projections

Best answer by Lizw
Hi
Managed to solve this issue with a quick report. Created a Permission set containing the ring fenced Projections. Used this as the input for the following query that excludes the Role and Other Permission sets.
SELECT DISTINCT projection, ROLE
FROM &AO..PERM_SET_ALL_AVAILABLE_PAGES
WHERE ROLE NOT IN ('IFS_ALL', 'IFSREADONLYSUPPORT',&ROLE)
AND PROJECTION in (SELECT projection
FROM &AO..PERM_SET_ALL_AVAILABLE_PAGES
WHERE ROLE = &ROLE)
ORDER BY projection, ROLE
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.