Making part of a list item private
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
November 19th, 2010 4:43am
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.
Free Windows Admin Tool Kit Click here and download it now
November 19th, 2010 5:00am
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
November 19th, 2010 5:21am
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
Free Windows Admin Tool Kit Click here and download it now
November 19th, 2010 5:30am
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.
November 19th, 2010 6:22am
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
Free Windows Admin Tool Kit Click here and download it now
November 19th, 2010 6:39am
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).)
MikeSP 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
November 19th, 2010 7:14am
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
Free Windows Admin Tool Kit Click here and download it now
November 22nd, 2010 10:11pm
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
November 26th, 2010 4:26am