SharePoint view permissions?

15 pts.
Tags:
SharePoint
SharePoint administration
SharePoint permissions
Sharepoint View Permission
Can someone please tell me if it is possible to assign permissions to unique columns for specific users? e.g: - User 1 can read columns a, b and s - User 2 can not see column c,v Perhaps through different views? Any help?

Answer Wiki

Thanks. We'll let you know when a new response is added.

By default, SharePoint does not have such feature which allow user set view permission below list level.

However there is a bullet-proof 100% workaround that can be applied out of the box..

This approach first makes the list only accessible via personal views. We then customize a personal view for each user, and finally secure the list by preventing the user from changing their personal view.

  1. As Site Admin user, copy a suitable permission level (eg Limited Contribute) for the list, but uncheck the ability to manage personal views (down the bottom) and name it “Limited Contribute – default view only”.
  2. Modify the default “All Items” view by adding the filter “ID, is equal to, 0″. This view no longer displays anything.
  3. Now set permissions for the list from List Settings – add the people (not groups) who get access to the list and initially give them “Limited Contribute” so they can all still create a personal view.
  4. This is the tedious part. Login as each user one by one. Create a Personal view for the current user based on the “All Items” public view. Remove the “ID is equal to 0″ filter and add the filter constraints you want to apply for this particular user. Even if all users have the same filter constraint you have to do this once for each user, as they all get independent personal views.
  5. Login as site Admin and bulk change all the users permissions to the permissions set “Limited Contribute – default view only” that prevents them managing Personal views.
  6. Hey presto, its done!

You can mix permission sets too – just make sure you remove the ability to manage personal views for each user or the list security is lost.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • N21
    To restrict the column "Approver's Comments" to usres with Manage Web permissions:
    <SharePoint:SPSecurityTrimmedControl runat="server" PermissionsString="ManageWeb">
    					<tr>
    						<td width="190px" valign="top" class="ms-formlabel">
    							<H3 class="ms-standardheader">
    								<nobr>Approver’s Comments</nobr>
    							</H3>
    						</td>
    						<td width="400px" valign="top" class="ms-formbody">
    							<xsl:value-of select="@Approver_x2019_s_x0020_Comments"/>
    						</td>
    					</tr>
    					</SharePoint:SPSecurityTrimmedControl>
    20 pointsBadges:
    report
  • N21
    As Mentioned by N21
    20 pointsBadges:
    report
  • Gena
    the company i work for, infowise, has a great product, named Smart List Pro ( http://www.infowisesolutions.com/product.aspx?id=SmartListPro ) it allows to define permissions for columns inside list item forms and define permissions and defaults for list views. check it
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following