R – Sharepoint Item Level Access & performance

data accesslistpermissionssharepoint

i have created a workflow activity that do give the item creater of a specific list full control on the item and set everyone else to read only access (permission)

someone told me that doing it this way (if i have a lot of users) the performance will go down dramatically

is that correct ?!!

if yes what is the best solution to create a list where any one can create new items but after the item is created only the creater can edit it and the rest of the users can read it only

Best Answer

Performance degradation will happen when you use large ACLs for each list item. Just make sure that item-level permissions basically have the minimum entries. For example:

  • The user that has permissions to edit that item
  • A single security group that contains all the users with only Reader permissions.

So, can Sharepoint offer these default permissions OOB? Not that I'm aware of. The only option that I can think of is using workflows that set these permissions dinamycally when the document is uploaded.

If you want to avoid performance degradation just make sure that you never display (or iterate using the object model) more than 2000 of those items in a Fine Grained Permissions list. THAT would definitely cause major performance issues.