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.