BT

InfoQ Homepage News Article: Column Level Security in SharePoint

Article: Column Level Security in SharePoint

Bookmarks

In this article, Mathew Dressel and Grzegorz Gogolowicz demonstrate how to implement column level security in Windows SharePoint Services and Microsoft Office SharePoint Server 2007.   Currently SharePoint does not provide this capability which leaves developers to develop their own solution when needing to secure columns of data for a specific subset of users to a given site.

The object of the article is to:

  • store data in a secure manner from unauthorized users
  • render secured data only to authorized users
  • only allow authorized users to modify secured data

To implement column level security the authors used:

  • Data Storage List
  • Custom Field Type
  • Deployment Solution Package

The authors have made the code available on on the MSDN Code Gallery.   Enjoy Column Level Security in SharePoint.

Rate this Article

Adoption
Style

Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Community comments

  • Is this available for download?

    by Milton Lopez /

  • Troubles with secure fields

    by Ivan Mezhebitskiy /

  • Doesn't work with exporting

    by Charles Kidder /

  • Secure fields

    by Marijan Broz /

  • Creating a "catalog" list...how?

    by Sluggo Fernandez /

    • Is this available for download?

      by Milton Lopez /

      Your message is awaiting moderation. Thank you for participating in the discussion.

      Great job on using standard SharePoint features to implement secure columns. Since this is a general-purpose solution, is it available for download for those of us who are a bit too busy to implement it ourselves?

      Thanks in advance.

    • Re: Is this available for download?

      by Matthew Dressel /

      Your message is awaiting moderation. Thank you for participating in the discussion.

      If you look in the conclusion section you will see a link to download the source and binaries.

    • Troubles with secure fields

      by Ivan Mezhebitskiy /

      Your message is awaiting moderation. Thank you for participating in the discussion.

      This solution works fine, but it seems that only SharePoint administrator user can create secure fields. In my case any other user receives "no access" error when trying to add a field. Though full access is granted for these users.

    • Doesn't work with exporting

      by Charles Kidder /

      Your message is awaiting moderation. Thank you for participating in the discussion.

      The feature is great but I can still export to a spreadsheet or open with access and see the data if I'm a person without rights to see the data on screen.

      Any ideas how to prevent seeing the data in access or excel?

    • Secure fields

      by Marijan Broz /

      Your message is awaiting moderation. Thank you for participating in the discussion.

      The feature is great but I need secure field to be choice (menu to choose from).
      Any ideas ?

      Thanks Marijan

    • Creating a "catalog" list...how?

      by Sluggo Fernandez /

      Your message is awaiting moderation. Thank you for participating in the discussion.

      Greetings:

      From within Site Actions --> Create, I don't see where/how to create a Catalog list as mentioned in the article (for the purpose of holding the secure data).

      Please, if someone can provide me guidance/advice on that issue, it would be greatly appreciated.

      Thanks...
      Ed in Tampa

    • Re: Secure fields

      by Ruby R /

      Your message is awaiting moderation. Thank you for participating in the discussion.

      Did you make it work? IF so could you/any one pl guide me, even I am trying to secure a choice field.

    • Re: Secure fields

      by Eitan Bach /

      Your message is awaiting moderation. Thank you for participating in the discussion.

      You can tryout "Infowise Smart List Pro" which extend the SharePoint lists and give them extra capabilities like - fields permissions, fields Value Validation, tabbed Interface, view permissions, default values and more.

      infowisesolutions.com/product.aspx?id=SmartListPro


      Regards,
      Eitan Bach

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

BT

Is your profile up-to-date? Please take a moment to review and update.

Note: If updating/changing your email, a validation request will be sent

Company name:
Company role:
Company size:
Country/Zone:
State/Province/Region:
You will be sent an email to validate the new email address. This pop-up will close itself in a few moments.