SharePoint Column/View Permission

SharePoint Column/View Permission Tutorial:

Firstly, Column Permission

SharePoint Column Permission can make column invisible or read-only to certain people. For instance, there is a list contained employee profiles. Everyone can view the basic information like name and ID. However, only the accountant can access to salary column, while administration staff have permission to all columns except salary column.

Invisible Column

There are three view types: Public View, Accountant View, and Administration View. One, without permission to a column belonging to a certain view, cannot access to this view also.

In list setting page, click "Column permission setting" and enter into column permission setting page.

The following is an example of giving ordinary staff like Tom column permissions. Add his name in "users/groups" editor box. Select "Address", "Cell Phone No.", "Salary", and "Leader" column, and move to the right box. These columns are read-only to Tom.

Setting Column permission to accountant is similar to setting for ordinary staff. Jerry is an accountant who has permission access to salary column.

Give Herny, an administration staff, corresponding permission.

Now, Tom can only choose "Public View", Jerry can access to "Public View" and "Accountant View", while Herny can view items in "Public View" and "Administration View"

In display form, Tom cannot see "Leader", "Address", "Cell Phone No." and "Salary" column.

Read-only Column

The information in employee profiles is input by different departments with corresponding permissions.

For instance, Jerry, an accountant, can only edit the salary column of each employee. Enter into the accountant setting page. Choose and move all columns except "Salary" to the right box. All the columns except "Salary" are read-only columns to Jerry.

In Edit form, Jerry can only edit salary column.

If current view contains read-only column, the "Edit in Datasheet" menu item in Action menu will be hidden to avoid users editing read-only columns.

There is another list containing Financial Reimbursement, Everyone can view the basic information such as Employee Name, Timing, Use to Describe and Account.

Attachment permission

Jerry, as an accountant, wants to create an item with an attachment, which is invisible for ordinary staff like Tom, but read-only for administrators like Herny.

Then we can edit the column permission setting for Tom and Herny.

After these settings, Tom cannot see the attachments, and Herny can only view the attachments while can not edit the attachments.