The Restrictions setting allows you to restrict viewing or editing permissions for particular columns. This functionality allows you to restrict specific users or groups from viewing or editing columns that they would normally be able to access.
Column restrictions can be added to project or shell, program and company level cost sheet columns and work package columns, but not the cost template.
A user may have general view and/or edit permissions on the cost sheet, but can be restricted from viewing or editing cost information in specific columns within the cost sheet. Users or Groups with Create permissions can set these additional column restrictions from within the cost sheet in User Mode.
Column restrictions differ from "hidden columns" in that users with edit and/or view permissions for the entire cost sheet will by default have edit and/or view permissions for each column in the cost sheet, unless restricted from doing so. "Hidden" columns are not displayed on the cost sheet, regardless of the permissions of the user.
Restriction setup affects Budget Distribution and Assigned Budget. If Assigned Budget is available on the cost sheet, the following applies:
- No Restriction setup for a user: User can view and edit both Budget distribution and Assigned Budget
- Disallow Viewing checked for a user: User cannot view and edit both Budget distribution and Assigned Budget. Cannot import Summary Budget
- Disallow Viewing unchecked for a user: User can view Budget distribution and Assigned Budget. Cannot import Summary Budget
- Disallow Editing checked for a user: User cannot view and modify Budget distribution and Assigned Budget. Cannot import Summary Budget.
- Disallow Editing unchecked for a user: User can view and modify Budget distribution and Assigned Budget. Can import Summary Budget
Restrictions and permissions:
- Opening a worksheet directly from the log window is based on the worksheet permission defined for that worksheet.
- Accessing and viewing worksheet data from a Cost Sheet column is subject to column restrictions. Worksheet ownership (creator) and permissions work on top of Cost Sheet column restrictions.
- Be sure you have cost sheet "Create" permissions. Users with create permissions for the cost sheet will be allowed to access the Restrictions button.
To set cost sheet column restrictions
- In User Mode, open the work package or project or shell, program or company level cost sheet.
- Click the Columns button. The Columns Log opens.
- Click the Restrictions button. The Edit Restrictions window opens.
- Click the Add button. The User/Group Picker opens.
The users or groups that are displayed in the picker are limited to those users and groups that have cost sheet permissions. For example, if you have given project or shell cost sheet permission to a single group, that group will display in the User/Group Picker window.
- Select the user or group to edit restrictions and click OK. The Edit Restrictions window opens.
- Select one or more user/group in the upper portion of the Edit Restrictions window (press the Shift or Ctrl keys to select more than one user or group). The permission settings for each cost sheet column are displayed in the lower portion of the window.
- For each column, you may set the following restrictions:
- Disallow Editing: if a user or group is not allowed to edit a column, then that user or group will not be allowed to add, modify, or delete data in any of the cells in the column.
- Disallow Viewing: select this checkbox if you want to restrict the user/group from viewing a particular column.
- Click OK.