Forum Discussion

ashmelburnian's avatar
ashmelburnian
Brass Contributor
Jul 05, 2019
Solved

Prevent deletion of SharePoint files

We had a situation where an end user accidentally deleted thousands for files under a SharePoint document library via OneDrive.

 

The document library itself is accessible to everyone within the company.

 

Is it possible to prevent users from deleting files within a document library and all subfolders?

 

All users currently have "Edit" permissions allowing users to add, update and delete all items. There doesn't appear to be a permission level that allows all this except for delete.

 

  • You need to create a new permission role and assign that to users. Go to the SharePoint site permissions, it's under advanced on the home page. Add a role and select just the permissions the user needs and not delete. Now go to library and change the user group permissions to that new role.
  • ashmelburnian 

    I am not an Admin of our SharePoint instance, but I do have the ability to create sub sites. I can’t create my own unique permissions either. I have to work within the defaults I’m provided. I also don’t want the Users deleting their folders on which they can Contribute as all the permissions on the folder go with the folder and it’s a headache to fix - maybe even detrimental depending on what files are lost and the retention policies in place. The “can’t be done” answer is less appealing to me than a slightly tedious solution that works.

     

    One option to consider trying - that works for me - is to:

     

    1.) Place a tiny txt file in the Member (User) [or Group folder] and then as Owner “Do not share” the txt file so it is only visible to the Owner. In other words, the Owner has Full Control on the txt file, and no one else has any access - therefore they don’t even see it in their folder on which they have Contribute permission. Then

     

    2.) Right-click on the txt file as Owner and “Check out” the file.

     

    It’s a bit of a hack, but if the Member with Contribute rights tries to delete the folder either intentionally or by accident (even when appearing empty) they will be told the folder has a file checked out for editing and they can not delete the folder. 

    If you have sub folders within the folder you wish retained, then placing this _.txt or do_not_delete.txt file in the sub folder will prevent easy deletion of both the sub folder and (all enclosing) folder(s). The Member’s file actions (i.e., create, rename, delete, etc.) on their own files are otherwise unaffected as only the txt file’s access is impacted.

    The obvious downside is this ”fix” takes clicks within each User “Contribute” folder, but depending on the number of Users and folders the Owner has within the site, it may be worth the time spent and help you rest easier knowing the folder‘s aren't easily deleted.

    If you have Admin control over the site I imagine you should be able to come up with a better way (i.e., faster and less tedious way) to achieve the same outcome.

    • tonyinthecloud's avatar
      tonyinthecloud
      Brass Contributor
      Thanks for the creative work-around for those of us in desperate need of a solution. This is something that SHOULD be an included feature on a tool that is promoted as a solution for businesses to use for their document management needs. Your 'half-way' implementation mentality is getting old Microsoft and you are pushing customers to competitors.
    • GS_Gordon's avatar
      GS_Gordon
      Copper Contributor

      Jeff_Nowak_Purdue_U_FW Hi, I liked your solution to this problem albeit, as you said, rather tedious to implement. The main problem would be remembering to insert the text file in every newly created folder.

       

      I'm interested to know whether you found another solution?

       

      Regards, George

  • CindyZ's avatar
    CindyZ
    Iron Contributor

    ashmelburnian I am also facing this same issue in that I'd like to prevent users from deleting files.  However, it also seems to prevent their being able to move files. 

    Could someone please confirm for me those two are also related.  Also, what else might be affected if you do not allow delete? 

    Anyone know of a User Voice to vote for this option.  It seems to be a frequent request -- to prevent delete but allow other options. 

     

    Thank you in advance for your help, everyone! 

    • collabrius's avatar
      collabrius
      Copper Contributor

      CindyZ 

      A bit of time has passed since this question, however in my experience the granular 'delete' permission is related to the following actions someone might want to do:

      • Delete,
      • Rename, and
      • Move

      NB: as aforementioned by others in this post

       

      When I implemented a delete restriction in document library where I wanted more control I created a workflow to be manually run which allowed someone to provide the new name of the file. It then renamed the file using a specific account that had elevated rights to the library.

       

      That was implemented on-premise and I am yet to re-create this online, however I imagine the logic would work the same.

       

      Hope this helps.

      • GS_Gordon's avatar
        GS_Gordon
        Copper Contributor

        collabrius That sounds very helpful for my situation, provided its works online.

         

        Would it be possible to use the same/similar method for moving a file when delete permission is off.

  • Alan Marshall's avatar
    Alan Marshall
    Steel Contributor
    You need to create a new permission role and assign that to users. Go to the SharePoint site permissions, it's under advanced on the home page. Add a role and select just the permissions the user needs and not delete. Now go to library and change the user group permissions to that new role.
    • Alireza Rahimifarid's avatar
      Alireza Rahimifarid
      Steel Contributor

      Alan Marshall 

       

      I agree but users always need to delete the files, you just need to train them also you are able to recover all the files after deletion. 

      • Sengyo's avatar
        Sengyo
        Copper Contributor
        You are right. I used Views to prevent users from deleting files from others. The ability to recover after deleting a file is also reassuring. Thanks.
    • Sengyo's avatar
      Sengyo
      Copper Contributor

      Alan Marshall 

       

      Great tip.  Noticed one drawback though.  The ability to rename files is linked to the Delete permission.  When you remove the Delete permission, the user can't rename files anymore either.

      • Alan Marshall's avatar
        Alan Marshall
        Steel Contributor
        That should only require edit rights as it's a property. Maybe someone at Microsoft can confirm this.
    • ashmelburnian's avatar
      ashmelburnian
      Brass Contributor

      Alan MarshallThanks for your help, much appreciated.

       

      The setting is under Site settings > Site permissions > Permission levels.

       

      • jillianarthur's avatar
        jillianarthur
        Copper Contributor

        ashmelburnian  I'm not seeing the Manage options on our SharePoint sites.  We are on a Government Tenant, so I'm wondering if that feature just isn't available yet or if it is something we can add to the menu.  

  • Hi ashmelburnian,

     

    I don't believe that is possible with out of the box permissions.

     

    Is an additional document library with read only permissions reasonable?

     

    I hope this helps.

     

    Norm

     

Resources