DescriptionBelow is the SOQL query we can create using Workbench to capture the Permission Sets associated with a given User or Profile via the Permission Set Assignment object
ResolutionQuery:
SELECT Id, PermissionSetId, PermissionSet.Name, PermissionSet.ProfileId, PermissionSet.Profile.Name, AssigneeId, Assignee.Name FROM PermissionSetAssignment WHERE Assignee.Name = 'JOHN SMITH'
Or retrieve all users associated with a specific PermissionSet like:
SELECT Id, PermissionSetId, PermissionSet.Name, PermissionSet.ProfileId, PermissionSet.Profile.Name, AssigneeId, Assignee.Name FROM PermissionSetAssignment WHERE PermissionSet.Name = 'Custom PermissionSet Name'
Note: The above code is an example and may vary depending on the organization’s customization.
Additional Reference:
Object Reference for Salesforce and Lightning Platform
Blog: Using SOQL to Determine Your Force.com User’s Permissions
