Skip to content

Instantly share code, notes, and snippets.

@surajp

surajp/get-privileged-users.soql

Created June 16, 2026 19:11
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save surajp/3ba14325c6ccf5de3ad5b36bb0d53e7f to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save surajp/3ba14325c6ccf5de3ad5b36bb0d53e7f to your computer and use it in GitHub Desktop.
Download ZIP
Get details of users with privileges that need phishing resistant 2FA
Raw
get-privileged-users.soql
SELECT Assignee.Id,
Assignee.Name,
Assignee.Email,
Assignee.Username,
Assignee.IsActive,
PermissionSet.Name,
PermissionSet.Profile.Name,
PermissionSet.PermissionsModifyAllData,
PermissionSet.PermissionsViewAllData,
PermissionSet.PermissionsCustomizeApplication,
PermissionSet.PermissionsAuthorApex
FROM PermissionSetAssignment
WHERE Assignee.IsActive = TRUE
AND (PermissionSet.PermissionsModifyAllData = TRUE
OR PermissionSet.PermissionsViewAllData = TRUE
OR PermissionSet.PermissionsCustomizeApplication = TRUE
OR PermissionSet.PermissionsAuthorApex = TRUE)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment