I am running SOQL queries to compare object permissions, but get duplicate permission for the same profile. For example, the "System Administrator" profile has two identical object permissions for the "Account" object. But why would there be two records? On the other hand, the same profile has two permission records for the object "Pricebook2" or "Product2", but one record has "ModifyAll" = true and the other record has "ModifyAll" = false
Could anybody explain the reason behind this?
Here is the SOQL-query I used for the profile "System Administrator":
SELECT Id, PermissionsCreate, PermissionsDelete, PermissionsEdit, PermissionsModifyAllRecords, PermissionsRead, PermissionsViewAllRecords, SobjectType, Parent.Profile.Name
WHERE Parent.Profile.Name = 'System Administrator'