Skip to content

Instantly share code, notes, and snippets.

@Patlatus

Patlatus/whichPS.soql

Created September 21, 2020 07:45
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Patlatus/c22c419638d123fd5b75f0de6e4dbd3e to your computer and use it in GitHub Desktop.
Save Patlatus/c22c419638d123fd5b75f0de6e4dbd3e to your computer and use it in GitHub Desktop.
Download ZIP
Find out which permission set provides read access to a field
Raw
whichPS.soql
SELECT ParentId FROM FieldPermissions WHERE
Field = 'CustomObject__c.CustomField__c'
AND SObjectType = 'CustomObject__c'
AND PermissionsRead = true
AND ParentId IN (SELECT PermissionSetId from PermissionSetAssignment WHERE AssigneeId = '005USerID0000AAA')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment