How Do I Restrict Views of a Custom List by Group in Sharepoint 2007

sharepointsharepoint-2007

I'm pretty new to Sharepoint and what I would like to do is create a huge master list of all our employees and then make different "views" on that person depending on the persons group

For example:

A new employee might have

  • Salary info
  • Security info
  • Personnel info
  • Contract info

I would like to have all that in one row (per employee) but then when someone from the hr group logs in they can only see Personnel and Salary or something like that.

If that is not an option is there a way to link tables across different lists?

Best Answer

Easy. 1 list. Several different views for that list, based on metadata - department, building, whatever. You can show different cols in each view. For instance...for HR, you'd show the salary col as well as the name col. For regular people, another view that does NOT show the salary.

Now we make a few web part pages. On each web part page, put a web part that shows our list. But it only shows one view of that list, with no real way to get to any others.

Now we restrict permissions for each of those web part pages to only the group(s) that you want to see it.

So - web part pages that show different views of the same list, and permission restrictions on those web part pages.

Related Topic