none
Limitation "Unique permissions limit - 50000" RRS feed

Answers

  • I got this error when I tried to break inheritance on the 50001 item.

    List Unique Permissions Error

    • Marked as answer by Sven W Monday, August 13, 2012 8:57 PM
    Thursday, August 9, 2012 11:46 PM

All replies

  • Unique Permisisons Limit is 50,000. View Threshold is 5000.
    Thursday, August 9, 2012 2:37 PM
  • Yes - that was a typo. 50000 not 5000.

    but what happens if you need to exceed 50000?

    Thursday, August 9, 2012 5:15 PM
  • I think it will allow to add new items but will not allow to break inheritance. I am trying with the below script to see what happens when I try to add the next item after completion.

    $web = Get-SPWeb <WebUrl>;
    $list = $web.Lists["Test Unique Permissions Limit"];
    (1..50000)|%{
    $item = $list.Items.Add();
    $item["Title"]=$_;
    $item.Update();
    $item.BreakRoleInheritance($True);
    }

    Thursday, August 9, 2012 6:08 PM
  • I got this error when I tried to break inheritance on the 50001 item.

    List Unique Permissions Error

    • Marked as answer by Sven W Monday, August 13, 2012 8:57 PM
    Thursday, August 9, 2012 11:46 PM
  • Hi,

    It would give a memory exception. I was facing this kind of issue in one of my projects which was having more than 15000 items and each items with 4 unique permissions. What i end up doing is to consolidate items with some common crieteria such as Project or Region or Country, create folders for each one of them and put the relevent documents inside the folder. Now in this case if you have 15,000 records divided in to say 1000 categories, you will end up having (say 5 permission per category), 5000 permissions. You can even create folder programatically or use client object model console app to create folders and migrate the records. Let me know how it goes..


    ganesh

    Monday, August 13, 2012 8:56 PM
  • You are right, 50000 is the default value for list unique permissions threshold in webapplication settings in central administration.

    Ofcourse there is a meaning behind this value. Usually the system has reduced performance without taking any additional thinking about appropriate management of your content.

    Testing shows that SP2010 SP1 with CU August 2011 and SQL 2012 shows improvements with large lists.

    Monday, August 13, 2012 9:01 PM
  • Also, as the number of uniquely secured items increases, BreakRoleInheritance for newly added items becomes slower and slower.
    Monday, August 13, 2012 10:26 PM