locked
Making part of a list item private RRS feed

  • Question

  • Hi,

    Can anybody tell me if it is possible to make part of a list item private? For instance say I have a list of client details, their name, ID and product should be viewable by everyone however their date of birth and address should only be available to a certain few.

    Thanks
    Claire

    Friday, November 19, 2010 9:40 AM

Answers

All replies

  • The lowest level of security is a folder within a List/Lib.

    There is no security at column/field level.

     


    2010 Books: SPF 2010; SPS 2010; SPD 2010; InfoPath 2010; Workflow etc.
    2007 Books: WSS 3.0; MOSS 2007; SPD 2007; InfoPath 2007; PerformancePoint; SSRS; Workflow
    Both lists also include books in French; German; Spanish with even more languages in the 2007 list.
    • Marked as answer by Lily Wu Thursday, November 25, 2010 8:28 AM
    Friday, November 19, 2010 9:58 AM
  • As Mike Walsh said, there is no OOTB column/field level security however this is do-able.

    Column level security is not a simple thing to do. Here is an good example implementation in WSS/MOSS that should still work with 2010 http://www.infoq.com/articles/Dressel-Gogolowicz-wss-security that you could adapt to your context and there are also a few 3rd party solutions that provide column level security.


    Florin DUCA Logica Business Consulting, France
    • Marked as answer by Lily Wu Thursday, November 25, 2010 8:28 AM
    Friday, November 19, 2010 10:19 AM
  • hello

    yes, there is no OTB functionality which allows you to configure permissions for field (in addition to Mike's reply - you can setup permissions for separate SPListItem, not only on folder (although technically folder is special SPListItem - probably Mike mean this)). But you can implement Custom Field Type which will be secured as you need


    Blog - http://sadomovalex.blogspot.com
    CAML via C# - http://camlex.codeplex.com
    Graphs visualization in Sharepoint - http://spgraphviz.codeplex.com
    Friday, November 19, 2010 10:28 AM
  • Yes, I should have written OOB/OOTB somewhere in my post.

    >  that should still work with 2010

    Not necessary to add this here as this is the pre-2010 SharePoint forum so posters here are looking for WSS or MOSS (or SPS 2003) answers.

     


    2010 Books: SPF 2010; SPS 2010; SPD 2010; InfoPath 2010; Workflow etc.
    2007 Books: WSS 3.0; MOSS 2007; SPD 2007; InfoPath 2007; PerformancePoint; SSRS; Workflow
    Both lists also include books in French; German; Spanish with even more languages in the 2007 list.
    Friday, November 19, 2010 11:19 AM
  • I was just trying to point out that there shouldn't be any issues in the case of a future migration to SP 2010 :)
    Florin DUCA MCSE 2003 +Security,MCTS config/dev WSS 3.0/MOSS, MCITP/MCPD SP 2010, MCPD ASP.Net 3.5, MCTS ISA 2006 Logica Business Consulting, France
    Friday, November 19, 2010 11:37 AM
  • I prefer to keep this forum clear of any 2010 comments because they only encourage follow-ups that are about 2010.

    I already don't understand why people post *new* posts here that are clearly about SP 2010 (I move about 10+ each day) so anything that stops 2010 follow-ups here (which I usually don't spot) is welcome.

    (Just an explanation. I understand why you added this comment. I see it of course from the point-of-view of a Moderator trying to keep these forums on topic (= pre 2010).)

     

    Mike


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS v3 FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Friday, November 19, 2010 12:11 PM
  • Hmm.  Given the sensitivity of the data, maybe it should be split into 2 diff lists.  Have the one list with public data, and the second list with a lookup to the first that then includes the secured data.  The second list can be locked down with permissions and the first left open without having to go through these unique security gyrations. 

    There are 3rd party tools that can pull the 2 lists together for a single report when/if that's needed.  CorasWorks has a parent/child control that should work for this.  However, without 3rd party tools, I don't think there is a way to pull the info from the two lists together into a single report (someone correct me if I'm wrong).  Given the nature of the information, it might be an understandable trade-off. 

    HTH.


    http://www.Twin-Soft.com
    Tuesday, November 23, 2010 3:09 AM
  • Hi,

    Thanks for all the suggestions. It's a shame it's not a bit easier to do. I found this download which does something similar http://code.msdn.microsoft.com/SecureField however doesn't meet my requirements as it only allows a value of 20 characters (also if you view the list as a datasheet the values are also visible to everyone)

    Thanks for the help

     

    Claire

    Friday, November 26, 2010 9:24 AM