SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need fine grained permissions on SharePoint document libraries not based on acls in the SharePoint content database.

We maintain a seperate SQL Server database containing organizational structures and mapping to SharePoint document libraries. This sql database should be the leading system for authorization permissions on document libraries. It supports groups as well as individual permissions, permission inheritance and cross-ownership permissions.

Creating the ACLs on the sharepoint document libraries (syncing the acls to the database) would be far too tedious even when using code to maintain the permissions.

What would be the best option to implement such a fine grained permission model? We also need SharePoint search results (and possibly FAST) to be trimmed accordingly.

Any suggestions welcome.

share|improve this question

migrated from Apr 29 '12 at 5:59

This question came from our site for professional and enthusiast programmers.

Did you get any reference for this? I have the same problem now! – Alvmad Jul 7 '14 at 11:33

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.