Ideally, I need a list of active users that are assigned to a Profile in which the 'Modify All Data' system permission is checked.

But if I can even, quickly, get a list of just the Profiles with that permission, I can use reports and Excel to do the rest.

Has anyone done this before?

1 Answer 1


On the profile, there's actually a Permissions*PermissionName* field for each permission that you can query against. It's using the field's API name.

enter image description here

In this case, you're interested in Modify all Data so the following SOQL gives you that

SELECT ID,Name FROM Profile WHERE PermissionsModifyAllData = TRUE

In terms of permission names, you can refer to this question to make sure you're getting the right one based on what you see in the UI as some labels and names might not match.

  • Fantastic! If I can press further, how might I get a list of all of the 'PermissionName' variables that are options in this context? Can I just assume that they're identical to the screen label with spaces removed?
    – Bob Mount
    Apr 14, 2021 at 13:57
  • Good question, it's actually the API name of the permissions you see in the screen so there are some mismatches and this question has some ways to make sure you're getting the right one. Apr 14, 2021 at 14:07
  • Great...Thanks again!
    – Bob Mount
    Apr 14, 2021 at 14:13

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .