locked
Column Level Security

    Question

  • I'd like to grant some users access to only some of the fields in the list. I know that there's no column level security in WSS 3.0. Does anybody have any idea how can I do this? Any help is appreciated.
    Tuesday, February 27, 2007 11:33 AM

Answers

  • Hi Alpesh,


    Kwizcom has been around for awhile and there stuff is generally good... However, I havent used there products since 2005 they were a little behind when SharePoint 2007 originally came out and a lot of the features they had for SharePoint 2003 were included in the 2007 release... Ive been usng the Bewise stuff for a couple of years and they rock....

    Ping back the post on what you find... the cool thing about Codeplex is that most of the folks share their source code so you can learn the methiods used to implement the features / solutions and modify them as necessary......



    Cheers,


    -Ivan


    Ivan Sanders http://www.linkedin.com/in/iasanders http://dimension-si.com/blog
    • Proposed as answer by Alpesh NAKAR Tuesday, December 08, 2009 12:35 PM
    • Marked as answer by Mike Walsh FIN Tuesday, May 31, 2011 5:02 PM
    Monday, September 28, 2009 4:35 AM

All replies

  • It is not possible to do this out of the box nor have I seen any 3rd party tools to do this (although it sure would be great to have).   I seem to recall reading in these forums that someone was able to do something similiar to this by writing their own add-in for the views although I cannot remember the exact details.

     

    Tuesday, February 27, 2007 12:06 PM
  • Thanks Gary. Are you talking about this post? It is #1 google result for «Sharepoint column level security». But it has two serious disadvantages. 1. The guy is not going to share the code, but I myself have no experience in programming and even don't know what to start with. I'm even ready to buy such a solution for a small fee (I need it for my personal use only). 2. This is sutable only to restrict write access, but my main task is to restrict view also.

    Thank you for your reply anyway.

    Tuesday, February 27, 2007 12:33 PM
  • I used a work around to achieve column level security. I made the column read only and hidden from New and Edit forms.
    The same could however be updated through workflows. Described the details in my blog at:

    http://vinaybhatia.blogspot.com/2009/09/column-level-permissions-in-moss-2007.html
    Saturday, September 26, 2009 4:22 PM
  • I think this can help you:
    http://blogs.msdn.com/g/archive/2009/01/22/column-level-security-in-sharepoint.aspx
    Juan Pablo. http://surpoint.blogspot.com/
    Saturday, September 26, 2009 10:09 PM
  • There are a few free solutions on codeplex:

    The first is SPViewPermissionSetting (Powered by Laurent Cotton Aka Suchii - Bewise) http://spviewpermission.codeplex.com/ that allows you to choose what groups have access to specific views

     

    The second is SPListDisplaySetting (Powered by Laurent Cotton Aka Suchii - Bewise) http://splistdisplaysetting.codeplex.com/ that allows you to select the columns that show up in the for new, display, and edit and to choose the group…

     

    There are a few more on the site like OfficeToolbox.SharePoint.Lists v1.0 that only allow you to lock down the column and not choose to allow groups to have different access. http://officetoolbox.codeplex.com/

     

    Note: When using the SPListDisplaySetting and the OfficeToolbox.SharePoint.Lists v1.0 solutions at the same time your results will not be consistent, deactivate one while testing the other…

    This does not represent the entire list of solutions to provide trhis solution, only the ones I have used previously



    Cheers,


    -Ivan


    Ivan Sanders http://www.linkedin.com/in/iasanders http://dimension-si.com/blog
    Sunday, September 27, 2009 12:27 AM
  • We are currently evaluating this product for one of the clients  from Kwizcom - the add on is called SharePoint List Forms Extensions Feature


    Alpesh Nakar Blog: http://alpesh.nakars.com/blog | Twitter: @alpesh SharePoint Resources: http://www.justsharepoint.com | Twitter @justsharepoint
    Monday, September 28, 2009 4:29 AM
  • Hi Alpesh,


    Kwizcom has been around for awhile and there stuff is generally good... However, I havent used there products since 2005 they were a little behind when SharePoint 2007 originally came out and a lot of the features they had for SharePoint 2003 were included in the 2007 release... Ive been usng the Bewise stuff for a couple of years and they rock....

    Ping back the post on what you find... the cool thing about Codeplex is that most of the folks share their source code so you can learn the methiods used to implement the features / solutions and modify them as necessary......



    Cheers,


    -Ivan


    Ivan Sanders http://www.linkedin.com/in/iasanders http://dimension-si.com/blog
    • Proposed as answer by Alpesh NAKAR Tuesday, December 08, 2009 12:35 PM
    • Marked as answer by Mike Walsh FIN Tuesday, May 31, 2011 5:02 PM
    Monday, September 28, 2009 4:35 AM
  • Hi Ivan,

    Thanks! Could do with open source solutions for sure. However client IT won't go anywhere near them :) I will give these a go for sure.

    Alpesh Nakar Blog: http://alpesh.nakars.com/blog | Twitter: @alpesh SharePoint Resources: http://www.justsharepoint.com | Twitter @justsharepoint
    Monday, September 28, 2009 4:41 AM
  • For reference of anyone looking for a solution for this;

    http://www.infoq.com/articles/Dressel-Gogolowicz-wss-security

    and the download; http://archive.msdn.microsoft.com/SecureField/Thread/List.aspx

     

     

    Hope this helps.


    Blog; http://www.the-north.com/sharepoint --- Posting is provided "AS IS" with no warranties, and confers no rights.
    • Edited by Mike Walsh FIN Tuesday, May 31, 2011 5:01 PM This is not a SP 2010 forum so do not give SP 2010 comments here.
    Tuesday, May 31, 2011 1:46 PM