Access right for a master WSS 3.0 task list

I have a master task list that has a department column. Is it possibe to create a view based on the department column such that any department could only see its own set of data, rather than the whole master task list.

I'm using WSS 3.0
AXISHKAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ImaCircularSawTechnical LeadCommented:
Hi,

SP2007 does not offer item level permissioning as a standard feature.  You can create a view and target the view for different users but they will still be able to read every item in the list.

To offer item level permissions you'll need to make some customisations such as the following examples:

http://blog.solanite.com/keith/Lists/Posts/Post.aspx?List=11564265-6153-4557-aee2-72d1f62fa4c1&ID=9

http://www.chakkaradeep.com/post/SharePoint-ndash3b-Setting-Item-level-permission.aspx

Hope this helps.
0
AXISHKAuthor Commented:
Thanks. Look in another way, Is it possible to create a master task list that will consolidate different task list in in the same portal area "List", supposing that each list has the same structure ?

If that's work, I could create each task list to individual users and grant the project owner the consolidated master list only. Any advise ?

Thanks
0
ImaCircularSawTechnical LeadCommented:
You'd need to use a webpart to do this.  Content rollup would possibly be the best one.  It would only show items two which users have access to, however, I'm not sure you'll get any security trimming as it's WSS and not MOSS.
0
ImaCircularSawTechnical LeadCommented:
Also, list need to be in the same site collection.  You won't be able to target other site collection with the standard content rollup webpart.
0
CloudedTurtleCommented:
depending on your level of experince with Javascript and Jquery. you could use JQuery in a Content Editor web part to give you this output... again depending on your experience.

I have done something similar using SPServices (a JQuery Plugin). I put the script libraries in a Document Library for reference.

This also will only pull content from the sites that the user has permissions to. So you would have to setup you Project Managers with View permissions on all the subsequent task lists.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.