Find out which permission set provides read access to a field

To find which permission set provides read access to a field, use the following 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')

view raw

whichPS.soql

hosted with ❤ by GitHub