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