0

Suppose that i have two lists like this

REGION_LIST [ RegionName(text), RegionResponsibles(multi-select peoplepicker) ]

ISSUES_LIST [Some issue related columns, Region(lookup) ]

Main requirement is that system should only let the related RegionResponsibles to enter issue for that Region, and also in the list view RegionResponsibles should only see the issues for regions which they are member of.

The thing is; i can programmatically create SPGroups and assign people to those groups than do item-level unique permissions for each issue item. BUT; sharepoint has boundaries and limits for lists containing lar number of unique permissioned items.

As my list will probably have large number of items, i am looking for a solution that i dont have to create unique permissions for each item? Does sharepoint offer any other solutions to these kinds of requirements?

I am now thinking of programmatically check if the user is eligible to add/update item for any region in custom Event Receiver and prevent in ItemAdded/ItemUpdated . That is ok for data entry. But what about viewing only the items they are related to? Any ideas are welcome. Thanks.

1
  • Actually, dividing the main list into many lists is not suitable for my case.
    – ozdogan
    Mar 28, 2013 at 15:52

1 Answer 1

1

In most cases I've encountered, the 'need' to have items secured in the way you describe is often merely a presumed solution to the problem of users sifting through too much data. Usually creating views tied to a certain field values will suffice.

If the items truly need that level of isolation then you might want to consider putting the issues themselves into separate lists and securing the lists as needed. You could then use an aggregator web part such as the Content Query for viewing cross-list issues. This is certainly not an ideal solution but does work in some cases.

1
  • Thanks but, setting up different lists is not suitable for my case.
    – ozdogan
    Mar 28, 2013 at 6:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.