Best way to set column level permission?
hi this is the scenario i would like to get assistance with: I have a custom list in which all users should be able to create new items. However, if items already exist in that list all users should be able to edit any item but SHOULD NOT be able to edit specific fields on the edit form; these fields should be non-editable for specific users and editable for others. What would be the best way to achieve this? I am using MOSS 2007 and SharePoint designer 2007. Thanks much
February 24th, 2011 9:40am

Hi, you can use 3rd party tool to achieve this please refer http://spstipsutilitypack.codeplex.com/ https://solutionfinder.microsoft.com/Solutions/SolutionDetailsView.aspx?solutionid=90b799af15bf49e68bf3453fdf5b9243&partnerid=e1621202-37eb-4406-93ce-4232671205ee&wa=wsignin1.0Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/ http://sharepointpratik.wordpress.com/
Free Windows Admin Tool Kit Click here and download it now
February 24th, 2011 10:14am

Thanks. Is is possible to use designer?
February 24th, 2011 10:32am

No, this is not possible with designer. 3rd party webpart would work: http://store.bamboosolutions.com/sharepoint-column-level-security.aspx--Cheers
Free Windows Admin Tool Kit Click here and download it now
February 25th, 2011 12:37am

Hi Danny, Its possible to use designer. Create a new custom editform. Insert two custom list form webparts(one with columns not enabled for editing & another with editable columns) in the same page. Set audience targetting for both the webparts based on your requirement (1st webpart will be for the people who can't edit the form & 2nd for others). So you will be having only one page. Each user will see only the webpart intended for his/her group.Thanks, Chanakya
February 25th, 2011 12:57am

Hi Danny, Its possible to use designer. Create a new custom editform. Insert two custom list form webparts(one with columns not enabled for editing & another with editable columns) in the same page. Set audience targetting for both the webparts based on your requirement (1st webpart will be for the people who can't edit the form & 2nd for others). So you will be having only one page. Each user will see only the webpart intended for his/her group.Thanks, Chanakya
Free Windows Admin Tool Kit Click here and download it now
February 25th, 2011 12:58am

Hi Danny, Its possible to use designer. Create a new custom editform. Insert two custom list form webparts(one with columns not enabled for editing & another with editable columns) in the same page. Set audience targetting for both the webparts based on your requirement (1st webpart will be for the people who can't edit the form & 2nd for others). So you will be having only one page. Each user will see only the webpart intended for his/her group.Thanks, Chanakya
February 25th, 2011 12:58am

These are all gr8 ideas!!! Thanks Chanakya for your suggestion this i will definitely try reason being i am trying my best not to use 3rd tools as i don't have server rights and access and any solution that i deploy would have to be client side. I am very very very rusty with coding (last time i coded was 4 years ago and hated every moment of it!) and my inclination is towards a totally code free solution. I am very new to development in SP and its taking me a while to warm up to doing stuff in VS (but it is inevitable) i have however spent quite sometime in designer and can get more done here by fiddling around. Will try and keep you posted. Thanks!!
Free Windows Admin Tool Kit Click here and download it now
February 25th, 2011 6:06am

These are all gr8 ideas!!! Thanks Chanakya for your suggestion this i will definitely try reason being i am trying my best not to use 3rd tools as i don't have server rights and access and any solution that i deploy would have to be client side. I am very very very rusty with coding (last time i coded was 4 years ago and hated every moment of it!) and my inclination is towards a totally code free solution. I am very new to development in SP and its taking me a while to warm up to doing stuff in VS (but it is inevitable) i have however spent quite sometime in designer and can get more done here by fiddling around. Will try and keep you posted. Thanks!!
February 25th, 2011 6:06am

I've tried this and failed, It would be great if you can elaborate more on this as i'm currently trying to do something similar to this without 3rd party tools as well
Free Windows Admin Tool Kit Click here and download it now
February 25th, 2011 6:09am

Hi Danny, MS.DNA You can achieve this by setting Target Audience also you can use a 3rd Party tool developed Bamboo Solutions Column Level Permission . View this link http://www.eggheadcafe.com/software/aspnet/34273481/restrict-access-to-a-specific-column.aspx. Hope this helps!Shrikant Datke SharePoint Server 2010 MCP| Developer| Administrator Blog: http://shrikantdatke.blogspot.com
February 25th, 2011 6:34am

Hi Danny, MS.DNA You can achieve this by setting Target Audience also you can use a 3rd Party tool developed Bamboo Solutions Column Level Permission . View this link http://www.eggheadcafe.com/software/aspnet/34273481/restrict-access-to-a-specific-column.aspx. Hope this helps!Shrikant Datke SharePoint Server 2010 MCP| Developer| Administrator Blog: http://shrikantdatke.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
February 25th, 2011 6:34am

Hi Danny, Another solution would be to insert JavaScript - AJAX code in the EditPage. The code reads information regarding the current user from Active Directory (maybe a custom attribute, a security group, etc..) - something that determines if it he has access to update some fields. If the user has no authority to update some fields they can be hidden.
February 26th, 2011 11:32am

Hi again Chanakya your suggestion is working only thing is i can't seem to find how to make the fields readonly :( ive tried to change the setting the controlmode to display but every time the edit page loads i keep getting errors generated.. Another question i have totally off point is are normal task lists supposed to generate over due notifications when the due date has expired in a task? i've created a couple of task list and created tasks but i dont get any notifications when the task becomes overdue...HELP???
Free Windows Admin Tool Kit Click here and download it now
March 2nd, 2011 10:03am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics