[SalesForce] How to fetch profileName and permssionSets assigned to the all active users based on profile name

Requirement:I need to fetch a data with username with profileName and permission Sets assigned to users based on profile.

Here I have written a Query for fetching user.
Below is the query

select  user.FirstName, user.profile.name FROM user where user.IsActive=true and  user.profile.name='Standard User'

Can anyone please modify the query so i will get all the users permission set assigned.

Best Answer

Please let me know if this works for you : SELECT count() FROM PermissionSetAssignment p WHERE p.PermissionSet.IsOwnedByProfile = false AND p.Assignee.Profile.Name = 'System Administrator'

Please mark this as best answer if it resolves your query.

Related Solutions

[SalesForce] Is it possible to assign Permission Sets Owned By Profile

It is not possible to edit PermissionSet's that are owned by Profiles, so unfortunately, no you cannot update the ProfileId field on PermissionSet to assign it to a new profile. As per the docs...

In API version 25.0 and later, every profile is associated with a permission set that stores the profile’s user, object, and field permissions, as well as setup entity access settings. Permission sets that are owned by profiles can be queried but not modified.

What you can do is write Apex code to query the respective PermissionSet objects for a profile to create a new PermissionSet (not associated with any profile) that you can you assign to one or more users, including users with the originating profile (once you assign them a lesser profile).

[SalesForce] How to fetch manager name and their profile along with username and userid

Does this work for you?

select userName,id,manager.name,manager.Id, manager.profile.name from user

Best Answer

Related Solutions

[SalesForce] Is it possible to assign Permission Sets Owned By Profile

[SalesForce] How to fetch manager name and their profile along with username and userid

Related Topic