I 'm designing a system with 100s of sites,1,000s of SP groups 1.000s of lists and 100.000s of documents. After a certain period of time, the documents will "move" from their current location to a different (sharepoint web application - record management?) archive site, and being replaced with "link to a document".

An SQL server will store the permissions of the archived documents, because with so many documents the limit of 50.000 unique permissions will be reached very qyickly. The SQL table will have two columns:the GUID of the document and a A.D. group that should have READ rights. An http handler will decide if the user is elligible to see a document and then call web app server to show it. So, the web app server will show a document that the user doesn't has access. Is this possible?

I could copy the desired document to a "scratch" list, but I wouldn't want that.

  • is archive site on sharepoint or somewhere else? also how you store the permission in sql? – Waqas Sarwar MVP Jan 15 '15 at 15:20
  • I have added these information to the question – XristosK Jan 15 '15 at 16:07
  • Why can't the user have access to the document in the archive site? – Choggo Jan 15 '15 at 16:08
  • Because there's a limits of 50.000 unique permissions – XristosK Jan 15 '15 at 16:17
  • 1
    I don't think you'll be able to tell OWA to let a user through if he doesn't have access to the file in SharePoint - so I'll keep and eye out to how you solve this. You could try moving your HTTP Handler to process the OWA requests to the files and BLOCK UNDESIRED access instead of allowing desired access. That would, sadly, imply having SharePoint think everyone can see a file, when they can't – Choggo Jan 15 '15 at 16:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.