I just have a quick question any workaround is fine or even an idea works well.My requirement is I need to find the users who have edit read delete access on reports and dashboards in the whole org. Manually checking may not be possible with profiles as well as permission sets because we have more than 261 users and 52 permission sets and 58 profiles. can anyone help me with this



You're going to have to query both Profiles and Permission Sets. Here are two queries I've used in the past:

SELECT Id,PermissionsEditPublicReports,PermissionsEditReports,PermissionsRunReports,PermissionsManageDashboards,PermissionsManageDynamicDashboards,PermissionsViewMyTeamsDashboards FROM PermissionSet

SELECT Id,PermissionsEditPublicReports,PermissionsEditReports,PermissionsRunReports,PermissionsManageDashboards,PermissionsManageDynamicDashboards,PermissionsViewMyTeamsDashboards FROM Profile
| improve this answer | |

You should be able to use this query to find what profiles have what report permissions:

FROM Profile

PermissionsCreateCustomizeDashboards and PermissionsCreateCustomizeReport allow you to delete reports and dashboards in your personal folder, while PermissionsManageDashbdsInPubFolders and PermissionsManageReportsInPubFolders allow you to delete reports and dashboards in public folders.

| improve this answer | |
  • 1
    Hi Nicholas, Thanks for the quick reply although I'm not able to execute the query as it states "INVALID_FIELD: PermissionsCreateCustomizeDashboards ^ ERROR at Row:3:Column:5 No such column 'PermissionsCreateCustomizeDashboards' on entity 'Profile'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names" – Noha Nithish Nov 26 '19 at 16:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.