Sample SOQL:
- SELECT Parent.Profile.Name, sObjectType, PermissionsCreate, PermissionsRead, PermissionsEdit, PermissionsDelete, PermissionsModifyAllRecords,
- PermissionsViewAllRecords
- FROM ObjectPermissions
- WHERE ParentId IN ( SELECT Id
- FROM permissionset
- WHERE PermissionSet.Profile.Name IN ( ‘System Administrator’, ‘Read Only’ ) ) ORDER BY sObjectType, Parent.Profile.Name
The above SOQL will give profile name, object name, create access, read access, edit access, delete access, modify all access and view all access.
Execute the SOQL in Data Loader to extract the values.