Uncategorized

Query to find Permission sets assigned to Users

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 […]