Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Item level security

  Asked By: Pankaj    Date: Apr 28    Category: Sharepoint    Views: 1994

Does anyone have experience with item-level security on list items?

We're interested to know if doing this affects performance due to
SharePoint having to apply security-trimming down to the list item
level before it renders the page.

Here's what we are trying to do:

Teams List - 30 items
- Used as the source of Lookup values

Secretary List - 100 items
- Each secretary belongs to a team

Assignments List - 500 items
- Each secretary team supports 1 or more people

All secretaries should see all other secretaries.
Secretaries should only see the assignments for their team because
notes on the assignments are confidential to the group.

We were thinking of creating security groups for each team and
restricting each assignment list item to a specific team.

On the web page:
1) Filter web part sending team choice to Secretary and Assignment
web part. Users can switch the view from team to team.

2) Secretary web part shows all secretaries for selected team.

3) Assignments web part shows all assignments for selected team. But
the logged in user will only be able to see the assignments for her



1 Answer Found

Answer #1    Answered By: Jonathan Scott     Answered On: Apr 28

I have a solution for your problem and I hope it can help you.
First, I made three list  for your senerio.
1. Team list

id member
1 abc
2 def
3 ghi

2. Secretary list

id member team(lookup field)
1 a 1
2 b 1
3 c 1
4 d 2
5 e 2
6 f 2

3. Assignment list

id task secretary team
1 write a document a 1
2 fix a bug d 2

so, I think you want to control item  permission for Assignment list.
What you need is to make [team]column have permission to the item it
resides, is that right? when a user join in a team or leave a team,
he will auto have permision or lose permission to the item which his
team resides.

Fortunately, SharePoint Permission Workflow resolve this problem,
because workflow is the best way to make all the things auto run.

You could download and try the free version of Permission workflow at

and set condition like this:
select column [team] have one permission(which in your case it should
be design) to items.

Didn't find what you were looking for? Find more on Item level security Or get search suggestion and latest updates.