SOLVED

Controlling access rights to columns in a SharePoint List

%3CLINGO-SUB%20id%3D%22lingo-sub-7402%22%20slang%3D%22en-US%22%3EControlling%20access%20rights%20to%20columns%20in%20a%20SharePoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-7402%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3Eis%20it%20possible%20to%20limit%20the%20access%20rights%20on%20specific%20columns%20in%20a%20SharePoint%20Lists%20to%20specific%20users%20of%20the%20site%3F%20We%20have%20a%20team%20site%20that%20we'd%20like%20to%20open%20up%20to%20an%20external%20supplier%2C%20but%20we%20would%20like%20them%20to%20modify%20only%20certain%20columns%2C%20to%20read%20others%20and%20to%20hide%20others.%3C%2FP%3E%3CP%3EHow%20can%20this%20be%20done%3F%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EChristian%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-7674%22%20slang%3D%22en-US%22%3ERE%3A%20Controlling%20access%20rights%20to%20columns%20in%20a%20SharePoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-7674%22%20slang%3D%22en-US%22%3ENo%2C%20Column%2Ffield%20level%20security%20is%20not%20available%20in%20SP.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-7567%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Controlling%20access%20rights%20to%20columns%20in%20a%20SharePoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-7567%22%20slang%3D%22en-US%22%3EThanks%20Kiril%20for%20the%20links.%20That%20helps.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-7562%22%20slang%3D%22en-US%22%3ERE%3A%20Controlling%20access%20rights%20to%20columns%20in%20a%20SharePoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-7562%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Fsharepoint.uservoice.com%2Fforums%2F329214-sites-and-collaboration%2Fsuggestions%2F7273440-add-permission-to-columns%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsharepoint.uservoice.com%2Fforums%2F329214-sites-and-collaboration%2Fsuggestions%2F7273440-add-permission-to-columns%3C%2FA%3E%20it%20was%20already%20asked%20and%20declined.%20However%20there%20are%20a%20few%20suggestions%20for%20permissions%20on%20views%3A%20%3CA%20href%3D%22https%3A%2F%2Fsharepoint.uservoice.com%2Fforums%2F329214-sites-and-collaboration%2Fsuggestions%2F13758354-list-view-audience%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsharepoint.uservoice.com%2Fforums%2F329214-sites-and-collaboration%2Fsuggestions%2F13758354-list-view-audience%3C%2FA%3E%20%3CA%20href%3D%22https%3A%2F%2Fsharepoint.uservoice.com%2Fforums%2F330318-sharepoint-administration%2Fsuggestions%2F12882252-allow-list-library-views-to-be-permission-based%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsharepoint.uservoice.com%2Fforums%2F330318-sharepoint-administration%2Fsuggestions%2F12882252-allow-list-library-views-to-be-permission-based%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-7438%22%20slang%3D%22en-US%22%3ERe%3A%20Controlling%20access%20rights%20to%20columns%20in%20a%20SharePoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-7438%22%20slang%3D%22en-US%22%3E%3CP%3EThanks.%20The%20problem%20is%20that%20we%20would%20like%20a%20solution%20that%20is%20sustainable%20and%20scalable%20in%20the%20near%20future%2C%20and%20since%20the%20modern%20UI%20will%20become%20anytime%20soon%20mandatory%20it%20would%20be%20nice%20to%20find%20an%20official%20way%20for%20doing%20this.%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-7434%22%20slang%3D%22en-US%22%3ERe%3A%20Controlling%20access%20rights%20to%20columns%20in%20a%20SharePoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-7434%22%20slang%3D%22en-US%22%3EIt's%20not%20possible%20by%20defaul...however%20you%20could%20use%20JSLINK%20(classic%20UI)%20to%20customize%20if%20a%20column%20has%20to%20be%20rendered%20or%20not%20dependibg%20on%20the%20user...this%20approach%20will%20not%20work%20in%20the%20new%20UI%20(still%20we%20need%20to%20know%20how%20to%20customize%20it)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-7403%22%20slang%3D%22en-US%22%3ERe%3A%20Controlling%20access%20rights%20to%20columns%20in%20a%20SharePoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-7403%22%20slang%3D%22en-US%22%3E%3CP%3EI%20don't%20believe%20it%20is%20possible%20to%20secure%20columns%20or%20views%20out%20of%20the%20box.%3C%2FP%3E%3CP%3EIt%20maybe%20possible%20to%20hide%20items%20with%20views%2C%20but%20that%20is%20not%20exactly%20secure.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20someone%20has%20a%20better%20answer%20too%20that.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20have%20a%20similar%20business%20request%20for%20allowing%20certain%20user%20to%20only%20see%20certain%20documents%20in%20a%20document%20library%20without%20having%20to%20manually.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20looked%20at%20Tru%20permissions%20automation%2C%20other%20than%20that%20I%20have%20come%20up%20empty%20on%20this%20one.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftruapps.portalfront.com%2Ftru-permission-automation-for-sharepoint.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftruapps.portalfront.com%2Ftru-permission-automation-for-sharepoint.html%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Hi,

is it possible to limit the access rights on specific columns in a SharePoint Lists to specific users of the site? We have a team site that we'd like to open up to an external supplier, but we would like them to modify only certain columns, to read others and to hide others.

How can this be done?

Thanks,

Christian

6 Replies

I don't believe it is possible to secure columns or views out of the box.

It maybe possible to hide items with views, but that is not exactly secure.

 

Hope someone has a better answer too that.

 

We have a similar business request for allowing certain user to only see certain documents in a document library without having to manually.

 

I have looked at Tru permissions automation, other than that I have come up empty on this one.

https://truapps.portalfront.com/tru-permission-automation-for-sharepoint.html

 

It's not possible by defaul...however you could use JSLINK (classic UI) to customize if a column has to be rendered or not dependibg on the user...this approach will not work in the new UI (still we need to know how to customize it)

Thanks. The problem is that we would like a solution that is sustainable and scalable in the near future, and since the modern UI will become anytime soon mandatory it would be nice to find an official way for doing this. Thanks.

Thanks Kiril for the links. That helps.
No, Column/field level security is not available in SP.