Insufficient access issue while deleting the record with Public Read/Write sharing settings

Question

User is getting "There's a problem saving this record. You might not have permission to edit it, or it might have been deleted or archived. Contact your administrator for help." exception for a record.

Scenario: User is trying to delete the record which is created by any other user. The object is set with Public Read/Write org-wide sharing settings and the user is assigned with Read/Create/Edit/Delete permission for the object through permission set.

Problem Statement: User is getting above mentioned error while trying to delete the record created by another user. And this exception is not even firing the trigger to debug more.

P.S. Only with "Modify All" access users are able to delete the records but it is not recommended to provide this permission to the users other than system admin.

Thanks in advance for the input.

Answer 1

There are only two possible ways wherein you can delete a record which is not owned by you and has OWD as public read/write.

1. The user trying to delete the record is higher in the role hierarchy than the owner of the record. (i.e. should be in the same branch in role hierarchy)
2. The user trying to delete the record has "Modify All" permission on that object or has "Modify All Data" permission on profile/permission set.

Answer 2

Role hirarchy is necessary to delete the record with "Delete" permission on profile / permission set + "Read/write" as OWD on that object.

If you don't want role hiererchy enabled for that object then you should have OWD "Read/Write" + "Modify All data" permission

If you want to give the permission through permission set then

1. create a custom permission and set the value to true in your existing permission set.
2. Create a custom button with Apes + VF/Lightning
3. In Apex code if the current user has that permission set assigned if so delete the record through apex.