{"id":4612,"date":"2012-11-20T13:15:51","date_gmt":"2012-11-20T05:15:51","guid":{"rendered":"http:\/\/www.sharepointboost.com\/blog\/?p=4612"},"modified":"2023-07-31T11:39:27","modified_gmt":"2023-07-31T03:39:27","slug":"columnview-permission-4-0","status":"publish","type":"post","link":"https:\/\/www.boostsolutions.com\/blog\/columnview-permission-4-0\/","title":{"rendered":"Column\/View Permission 4.0"},"content":{"rendered":"<p>Maybe you have a business requirement in SharePoint list to restrict visibility of some information to some users based on security or other considerations. Also you may want to disable some actions such as <strong><em>Create View, Edit View, E-mail a Link, Export to Excel<\/em><\/strong>, etc. for some users or set? different default views for different users.<\/p>\n<p><a href=\"http:\/\/www.BoostSolutions.com\/columnpermission.html\" target=\"_self\" rel=\"noopener noreferrer\">Column\/View Permission 4.0<\/a> can easily help you complete the above requirements.<\/p>\n<p>Compared with the previous version of Column\/View Permission, this version has a new UI that makes it clear and easy use. As well there is a new central area for viewing and managing permissions and a Preview function which helps administrators quickly understand permissions for different users and groups. Upgrading to Column\/View Permission 4.0 will give you a distinct advantage over the previous version and will also give you more powerful conditions and the ability to hide columns in datasheet view.<\/p>\n<p>Let us now look at a how we can complete the requirements we mentioned above.<\/p>\n<p><!--more-->Here are the parameters for this case study:<\/p>\n<ol>\n<li><em>In this list, four fields need to be hidden for all users except the manager. Here we assume that all views, including one or all of the four fields, except My Task view need to be hidden.<\/em><\/li>\n<li><em>A default view needs to be set for different user groups so that it&#8217;s convenient to access the view which they visit the most.<\/em><\/li>\n<li><em>Set up a permission so that some users cannot create and edit view and set alert on this list.<\/em><\/li>\n<\/ol>\n<p>Now let us take a step-by-step look at how to achieve our goal.<\/p>\n<ul>\n<li> Go to the <strong><em>View Permission Settings<\/em><\/strong> page. To do this click <strong>Column\/View Permission<\/strong> and then select and click <strong>Manage View Permission<\/strong> on the ribbon menu.<\/li>\n<\/ul>\n<p><a href=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic1.png\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-4613\" title=\"sharepoint view permission pic1\" src=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic1.png\" alt=\"\" width=\"169\" height=\"113\" \/><\/a><\/p>\n<ul>\n<li>Enter the main page by clicking ?<strong><em>Add Permission Part<\/em><\/strong><\/li>\n<\/ul>\n<p><a href=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic2.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-4614\" title=\"sharepoint view permission pic2\" src=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic2.jpg\" alt=\"\" width=\"842\" height=\"236\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic2.jpg 842w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic2-300x84.jpg 300w\" sizes=\"(max-width: 842px) 100vw, 842px\" \/><\/a><\/p>\n<ul>\n<li>In the <strong><em>Add Permission Part<\/em><\/strong> page, input a part name<strong> <\/strong>you would like to add in the <strong>Part Name<\/strong> box.<\/li>\n<\/ul>\n<p><a href=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic3.png\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-4615\" title=\"sharepoint view permission pic3\" src=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic3.png\" alt=\"\" width=\"1078\" height=\"218\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic3.png 1078w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic3-300x60.png 300w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic3-1024x207.png 1024w\" sizes=\"(max-width: 1078px) 100vw, 1078px\" \/><\/a><\/p>\n<ul>\n<li>In the <strong>Include Users <\/strong>section, select the <strong><em>All users<\/em><\/strong> radio button to included all users.<\/li>\n<\/ul>\n<p><a style=\"color: #ff4b33; line-height: 24px;\" href=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic4.png\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-4616\" title=\"sharepoint view permission pic4\" src=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic4.png\" alt=\"\" width=\"1078\" height=\"218\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic4.png 1078w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic4-300x60.png 300w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic4-1024x207.png 1024w\" sizes=\"(max-width: 1078px) 100vw, 1078px\" \/><\/a><\/p>\n<ul>\n<li>In this step, we will assume that the information of all managers is in another list. In the <strong>Exclude User<\/strong> section, click the <strong>Choose user\/group columns from another list<\/strong>. In the dialog window, select the <strong>Site <\/strong>and <strong>List<\/strong>. Select the <strong>user\/group columns<\/strong> that will be used to specify the user.<\/li>\n<\/ul>\n<p><a href=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic5.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-4617\" title=\"sharepoint view permission pic5\" src=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic5.jpg\" alt=\"\" width=\"921\" height=\"384\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic5.jpg 921w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic5-300x125.jpg 300w\" sizes=\"(max-width: 921px) 100vw, 921px\" \/><\/a><\/p>\n<ul>\n<li>Now you have to set conditions to exclude the manager. In the same dialogue window, in the <strong>Condition<\/strong> section, click <strong><em>Edit.<\/em><\/strong> In the condition dialogue window you can set conditions to filter a selection of users.<\/li>\n<\/ul>\n<p><a href=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic6.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-4618\" title=\"sharepoint view permission pic6\" src=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic6.jpg\" alt=\"\" width=\"820\" height=\"513\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic6.jpg 820w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic6-300x187.jpg 300w\" sizes=\"(max-width: 820px) 100vw, 820px\" \/><\/a><\/p>\n<ul>\n<li>After adding the external list settings, your settings dialogue window should look like the screenshot below.<\/li>\n<\/ul>\n<p><a href=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic7.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-4619\" title=\"sharepoint view permission pic7\" src=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic7.jpg\" alt=\"\" width=\"836\" height=\"178\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic7.jpg 836w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic7-300x63.jpg 300w\" sizes=\"(max-width: 836px) 100vw, 836px\" \/><\/a><\/p>\n<ul>\n<li>In the <strong>Permission Settings<\/strong> section, check the box next to the <strong>Disable create view (both public and personal).<\/strong><\/li>\n<\/ul>\n<p><a href=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic8.png\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-4620\" title=\"sharepoint view permission pic8\" src=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic8.png\" alt=\"\" width=\"834\" height=\"265\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic8.png 834w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic8-300x95.png 300w\" sizes=\"(max-width: 834px) 100vw, 834px\" \/><\/a><\/p>\n<ul>\n<li>Still in the <strong>Permission Settings<\/strong> section, under the <strong>Set View Permissions<\/strong>; from the <strong>Access Type<\/strong> drop-down menu, set ?all views as <strong>Hidden<\/strong>, except the <strong><em>My Task<\/em>s<\/strong> view, which will be set as <strong>Full Access<\/strong>. Under the <strong>Disable\/Enable Ribbon Button (Click to disable\/enable)<\/strong>, disable the ribbon button <strong><em>Set alert on this list <\/em><\/strong>and check the box under the <strong><em>Disable Edit View <\/em><\/strong>for <strong><em>My Task<\/em>s<\/strong> view.<\/li>\n<\/ul>\n<p><a href=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic9.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-4621\" title=\"sharepoint view permission pic9\" src=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic9.jpg\" alt=\"\" width=\"1313\" height=\"335\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic9.jpg 1313w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic9-300x76.jpg 300w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic9-1024x261.jpg 1024w\" sizes=\"(max-width: 1313px) 100vw, 1313px\" \/><\/a><\/p>\n<ul>\n<li>In the <strong>Set Default View <\/strong>section set the <strong><em>My Tasks<\/em><\/strong> view as the default view by checking the box next to <strong>Enable default view settings<\/strong>.<\/li>\n<\/ul>\n<p><a href=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic10.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-4622\" title=\"sharepoint view permission pic10\" src=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic10.jpg\" alt=\"\" width=\"987\" height=\"93\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic10.jpg 987w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic10-300x28.jpg 300w\" sizes=\"(max-width: 987px) 100vw, 987px\" \/><\/a><\/p>\n<ul>\n<li>Click OK to save all of the above settings.<\/li>\n<\/ul>\n<ul>\n<li>Enter the main settings page and click <strong>Preview<\/strong> to quickly preview the global settings.<\/li>\n<\/ul>\n<p><a href=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic11.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-4623\" title=\"sharepoint view permission pic11\" src=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic11.jpg\" alt=\"\" width=\"850\" height=\"855\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic11.jpg 850w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic11-150x150.jpg 150w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/11\/sharepoint-view-permission-pic11-298x300.jpg 298w\" sizes=\"(max-width: 850px) 100vw, 850px\" \/><\/a><\/p>\n<ul>\n<li>Once the global settings are in place, you can check whether the above settings have taken effect by logging in as a manger and as a general user.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Maybe you have a business requirement in SharePoint list to restrict visibility of some information to some users based on security or other considerations. Also you may want to disable some actions such as Create View, Edit View, E-mail a Link, Export to Excel, etc. for some users or set? different default views for different [&hellip;]<\/p>\n","protected":false},"author":14,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[347],"tags":[247,444],"_links":{"self":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/4612"}],"collection":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/users\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=4612"}],"version-history":[{"count":6,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/4612\/revisions"}],"predecessor-version":[{"id":9198,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/4612\/revisions\/9198"}],"wp:attachment":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=4612"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=4612"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=4612"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}