need to find modifyall permission for all profiles and for all objects

Question

I am unable to figure out the relation between the objects. I want to extract modifyall permission for all the available user profiles for all objects(standard and custom). I tried using the query

 SELECT Assignee.Name, PermissionSet.Id,
 PermissionSet.isOwnedByProfile, PermissionSet.Profile.Name,
 PermissionSet.Label FROM PermissionSetAssignment WHERE PermissionSetId
 IN (SELECT ParentId FROM ObjectPermissions WHERE SObjectType =
 'Account' AND PermissionsRead = true)

But it is unable to fulfill the criteria. Also the above query does not return the profile name insted it is returning [object Object] for the column PermissionSet.Profile.Name in the query

Kindly suggest if there is any other way to solve this problem!

Or if we can write a query to extract table with fields like :
Profile Name sObject PermissionRead PermissionModifyAllRecords etc.

Thankyou

Answer 1

When you go for more than 2 level it will display as [object.object] than its value in developer console query.

If you are interested only on profile then try the below,

SELECT Profile.Name from PermissionSet  WHERE Id
 IN (SELECT ParentId FROM ObjectPermissions WHERE SObjectType = 'Account' AND PermissionsRead = true)

Answer 2

I think it might help you.

List<PermissionSetAssignment> lst = [SELECT Assignee.Name, PermissionSet.Id, PermissionSet.isOwnedByProfile, PermissionSet.Profile.Name, PermissionSet.Profile.Id,
 PermissionSet.Label, PermissionSet.Name 
 FROM PermissionSetAssignment WHERE PermissionSetId 
 IN (SELECT ParentId FROM ObjectPermissions WHERE PermissionsRead = true)];

System.debug(JSON.serialize(lst));