Setting up roles and permissions in the Security window
Note: You must be a Sage Estimating administrator to set up roles and permissions.
Use this window to set up your Sage Estimating roles and permissions. Add new users, define new roles, and add corresponding feature permissions to roles in this window.
On the Estimates tab of this window, you can also:
- Set user permissions for individual estimates.
- Allow all users to view and edit all estimates, or limit the ability to view or edit individual estimates' user permissions according to their roles existing permissions by allowing all users.
Security permissions are assigned on an instance-wide basis. That is, the Estimating Management Console assigns all roles and permissions you define for the SQL Server instance selected in the Catalog pane to all Sage Estimating databases in that instance. For example, if you select an instance in the Catalogs pane of your Estimating Management Console called SAGE_EST_12_1, the individual users, groups, roles, and permissions you create in the Security window apply to all Sage Estimating databases in the SAGE_EST_12_1 instance.
Right-click the estimate database listed in the left-hand pane, and then select Turn security on or Turn security off to turn on or turn off the security feature.
To open the Security window:
Click [Security] at the top of the Estimating Management Console.
-
In the Security window, right-click the estimate database in the left-hand pane .
-
Select Turn security on to turn on the security feature for the instance, or select Turn security off to turn it off.
Note: Only one option appears, depending on whether security is already enabled or disabled.
The Estimating Management Console preserves your security setup. Any roles and permissions you define prior to disabling the security feature are restored if you turn it back on.
For example, if you add APerez to the Users list and assign this person to the Estimators role before disabling security, the person is restored to the Estimators role if you turn on security again.
Important! Ensure an individual user logs off Sage Estimating before making changes to his or her permissions.
-
In the Security window, click the Users tab.
-
On the Users tab, click [Add] to open the Add User window.
-
To set up users with Windows authentication, on the Windows Authentication tab of the Add User window:
-
(Optional) Select a role to associate with the user. You can assign the role later using the Users tab.
-
If you know the user or group ID you want to add, type it in the User or Group ID box, and then click the [ ] button.
If you don't know the ID, click the[
] button , and then:-
In the Select User or Group window, click the [ ] button, and then click [ ] to generate a list of all the user IDs and group IDs on the network to which the Estimating Management Console is connected.
-
Select a network user ID or group ID from the resulting list, and then click [
].The program adds the ID to the Enter the object name to select box.
-
Click [
] again.
-
-
Click the
button.Estimating Management Console adds the user to the Users to Add grid on the tab. If you entered or selected a group ID, Estimating Management Console adds all the users in the group, as well as users from any subgroups within that group.
-
In the Users to Add grid, select the checkbox beside each user you want to add.
Tip: A checkbox in the header of the Users to Add grid indicates whether any users are selected. You can select or clear all the user selections quickly just by selecting or clearing this checkbox.
-
-
To set up users with SQL Server authentication, select the SQL Server Authentication tab and then:
-
From the Role list, select the role to assign to the user.
-
In the User ID box, type the name or ID of the user.
Important! You need to create new users when setting them up with SQL authentication. Existing SQL users are not available for selection in the Add User window.
-
In the Password box, enter the user's new SQL password.
-
In the Confirm password box, enter the same password again.
-
Select local security options that you want to enforce for the user:
-
Select Enforce password policy to make sure that the user's password meets criteria specified in Microsoft Windows Security Policy.
-
Select Enforce password expiration to make sure that the user changes their password after a period of time specified in Microsoft Windows Security Policy.
-
If you select User must change password at next login, the next time the user tries to log on, they are prompted to change their password.
-
-
-
Click [OK] in the Add User window.
The user or users associated with the selected user or group ID appear in the Users grid of the Users tab.
Important! Ensure an individual user logs off Sage Estimating before making changes to his or her permissions.
-
In the Security window, click the Users tab.
-
Select a user on the Users grid.
-
Click a role in the Roles list to assign the selected user to it.
The Features list displays the corresponding tasks to which the role has permissions (and users assigned to the role).
Important! At least one user must be assigned to the administrator role at all times. Attempts to remove the last user from the role result in an error message.
-
In the Security window, click the Roles tab.
-
Click [Add Role] to open the Add Role window.
-
In the Add Role window, type a name for the new role in the Name box and an extended description in the Description box.
Use the extended description to provide helpful identification information later, such as the purpose of the role.
-
Select the checkbox next to one or more tasks in the Features list to provide users assigned to the role with access to the tasks.
Clear the checkbox next to a task to prevent users with the role from accessing it.
Important! At least one user must be assigned to the administrator role at all times. Attempts to remove the last user from the role result in an error message.
If you have the appropriate permissions, you can assign user permissions on an individual estimate basis. For example, you can grant a user permissions to view or edit estimate A, but not estimate B. Follow this procedure to assign individual estimate permissions:
Important! Ensure an individual user logs off Sage Estimating before changing his or her permissions.
- In the Security window, click the Estimates tab.
- Clear the Allow all users to view and edit all estimates option if it is selected,
- In the Estimates pane, locate the estimate to which you want to assign permissions.
- In the users grid below the Estimates pane, locate an user to whom you want to grant specific permissions and select the checkbox or checkboxes as desired:
- View. Allows the user to view the estimate but not save changes.
- Edit. Allows the user to view, edit, and delete the estimate.
If you do not assign permissions for individual estimates, other users will not be able to view or edit an estimate unless they create it or they have administrative privileges assigned through the Estimating Management Console.
You can override individual estimate security assignments for all users, allowing all users to view and edit estimates according to their roles, without having to assign View and Edit permissions individually to each user for each estimate.
Important! Ensure users are logged off Sage Estimating before changing permissions.
- In the Security window, click the Estimates tab.
- In the Estimates pane, select the Allow all users to view and edit all estimates checkbox.
Note: Turning on general security overrides existing security assignments, but it does not delete them. To restore individual user and estimate assignments, you simply clear the Allow all users to view and edit all estimates checkbox.
Tabs in this window
Tab | Notes |
---|---|
Users tab | Add individual users and groups to the list of authorized Sage Estimating users; assign users and groups to roles. |
Roles tab | Define roles and associate task or feature permissions with each role. |
Estimates tab | Set user access and permissions to individual estimates. |