Print this page

Permission Set & User Report

Knowledge Article Number 000194120
Description As of now, we cannot create a report on permission set and permission set assignment to a user.

However, below query on Permissionsetassignment object in workbench will give us the permission set information and the assigned user ID, User Role, User Profile. Etc.

For more information about workbench and its usage, please click here.

SELECT p.Assignee.Name, p.Assignee.ID,, p.PermissionSet.Label,p.PermissionSet.ID
FROM PermissionSetAssignment p WHERE p.PermissionSet.IsOwnedByProfile = false ORDER BY p.AssigneeId, p.PermissionSetId

promote demote