A SharePoint list with different set of access to different people

I have a list which contains employee data that is retrieved from ORACLE.
I want this list to be viewable as.

1. Every employees data is only viewable to its Manager and Manager's Manager and so ON.

One person can see data of its direct reports and it's direct report's direct report's.

Any Ideas.
 I have already tried with user filter web part please

The System is SP2010.
LVL 9
kukdaiAsked:
Who is Participating?
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.

abhitrigCommented:
Create a custom webpart that checks the user's direct reports(most likely from AD or from the list itself) recursively and then pulls the employee data from the mentioned list. Once you have the recursive logic built in, it should be easy to display the data in a grid view.

Another option (NOT Recommended but a possibility) could be to set individual item level permissions  once the list data has been populated.


0
kukdaiAuthor Commented:
any piece of info for the logic i am newbeu to sharepoint development if you have any piece of code regarding that i would love to go through it
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

kukdaiAuthor Commented:
that doesn't work since views can be seen by all and my requirement is not creating a different view it is filtering data with in the list only.
In case of views i might have to create lot of views....
0
abhitrigCommented:
I will need fore insight into your list...but from a logic perspective:
-Create a SP webpart
http://msdn.microsoft.com/en-us/library/ff597539.aspx
-Query your LDAP/AD/SAP and find the usernames for the direct reports recursively. Its just C# at this point
http://stackoverflow.com/questions/190516/getting-all-direct-reports-from-active-directory
http://www.codeproject.com/KB/system/QueryADwithDotNet.aspx?msg=2206624
-Create a CAML query to the list to filter the usernames from the selection in Step 2
-Show the results in a SPGridview within the webpart.
http://social.msdn.mic
rosoft.com/Forums/hu-HU/sharepointdevelopment/thread/a78f17fc-9a89-4267-a151-b15044c6e03f

HTH
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
kukdaiAuthor Commented:
partially helpful
0
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.