6.03.01 Setting Estimator Access Levels (Security)

Access Levels help to protect a database by allowing an administrator to limit what each estimator can do/access in a particular database. This ensures only employees with approved access can make updates or changes to Bid and/or database information. Employees and Access Levels are database specific so each database can have different users/access levels.

Access Levels for employees are set from the Estimator List (Master). Access Levels are recommended, especially when multiple users are sharing a database. To use Database Logins, there must be at least one user assigned the Access Level of "Administrator."

Database security is not bid-specific. Changing a user's Access Level/Rights can affect their access to every Bid in the database. Understanding the consequences of making changes to database security is important before implementing.

Assigning an Access Level to an Estimator

Click Master > Estimators to open the Estimators List
Select the appropriate Access Level for each employee from the drop down - by default, when Quick Bid is installed, only Administrator access level is created, follow the instructions below to create new Access Levels

Click OK to close the Master Estimator List

Creating an Access Level

To access the Security Access Levels screen,

Click Master > Estimators, the Estimator List opens
Click Access Levels, the Access Levels dialog box opens
Click New - a blank line is added under the Description field
Type in the Description (name) for this Access Level and press <Enter>

If employees assigned to this Access Level are to be have Administrator functions (ability to change Database properties and add/modify employees), put a check in the box next to Set as System Administrator. This Access Level will have Full Access to all Database tables regardless of the specific table settings.

Set Access Levels for a specific Database table by clicking on the cell next to the Database Table under the View column to select the cell, set Access Levels for each table or function (see the chart below for a description of what each setting does)
Click OK to return to the Estimator List (Master) dialog

Access Levels Settings

Below is a explanation of the various options available for setting security rights in Quick Bid.

Database Table	Full Access	Read Only	No Access
Master Items (these are the ITEMS stored in the database (Master > Items))*	Estimator will be able to add/modify/delete Master Items from the database such as updating pricing, adding/deleting, changing sizing, production rates. Master items cannot be deleted, however, if they are used in an Assembly or Chain.	Estimator will be able to review the entire Master Items LIST but will be unable to make changes. Once a Master Item is brought into a Bid, however, the user would be able to make changes to it that affect THAT Bid only.	Estimator will not be able to access the Master Item LIST although, they can use Type Ahead function to add an Item from the master list into to Bid. Once there, they can modify the BID LEVEL item. They cannot save any changes to Master Items.
Other's Bids (based on who is listed as Lead Estimator on the CoverSheet)	Estimator will be able to SEE AND EDIT all bids in the database whether they are the Lead Estimator or not.	Estimator will be able to ACCESS but will not be able to EDIT bids for which they are not the Lead Estimator. The Bids list will show all bids in the database.	Estimator will not be able to access any bids for which they are not the Lead Estimator. The Bids list will not display these bids either.
Bids List (the Bids Tab)	Estimator will be able to add, modify and delete any Bid that displays on the Bids Tab, regardless of who the Estimator is. This overrides any restrictions set for the Other's Bids Table.	User will not be able to create new bids, however, based on Other's Bids setting, may be able to DELETE or modify an existing Bid including creating alternates/changes orders. Estimator cannot Add, Delete Base Bids, Folders or Import a Bid, however, they CAN add/modify/delete Alternates and CO's for existing bids.	User has no access or view capability on the Bids Tab. This is used primarily for database Administrators - someone assigned to update things like pricing, contacts, etc. Estimator will not be able to see ANY bids in the database nor will they be able to add any information to the Bids Tab. This is generally reserved for a database administrator - someone that is responsible for setting up Master items/estimators, but doesn't actually do estimates.
Master (this is the Master MENU)	The entire Master Menu will be available to a user. HOWEVER, if the are not allowed to change Master Items or Payroll Classes, they will be only be able to VIEW those 2 categories. Estimator will be able to access all items on the Master menu. Settings in the Payroll Classes Access Levels overrides this setting, though.	User will be able to VIEW all Master Menu selections but will not be able to make changes to the actual tables unless they specifically have Full Access rights to Master Items and/or Payroll Classes. Estimator will be able to VIEW Master menu tables but will be unable to add/modify/delete items within the tables. This is overridden, by Payroll Classes setting.	User will NOT be able to VIEW any Master Menu selections unless they specifically have Full Access or Read Only rights to Master Items and/or Payroll Classes. All menu items on the Master list will be inactive/grayed out.
Payroll Classes (the Master Payroll Classes)	User will be able to make changes to Master Payroll Class information such as adding and deleting payroll classes, hourly rates, burden, etc. Estimator will be able to Add/Modify/Delete Payroll Classes. Regardless of what Access Level is selected under "Master"	User will be able to access the Master Payroll Classes list, however, they will not be able to save changes to any Payroll Class. Estimator will be unable to add or edit Payroll Classes but would be able to access the dialog from the Master menu but updates will not be allowed.	User will have no access to the Master Payroll Classes LIST. They can still use Payroll Classes from the Master list in their Bid, but they cannot invoke the actual list, nor can they save changes to Master Payroll Classes. Estimator will be unable to add or edit Payroll Classes but would be able to use items that use Payroll Classes in a Bid. They will also be able to make changes to Bid Level Payroll Classes on the Payroll Tab . Master menu option for Payroll Classes will be inactive/grayed out.

*When a Bid is imported into a database, Items included in that Bid that do not exist in the database CAN BE added to the master, regardless of the user's rights - this setting is controlled in Database Options - General Tab.

Even if a user is prevented from making changes to Master Items or Payroll classes, they will still be able change BID LEVEL Items and Payroll class information. Once an Item or Payroll Class is used, it is copied from the Master Tables into a BID LEVEL table for Estimator use.

Access levels rights for Master Items and Payroll Classes can override settings for Master (Menu).

Access level rights for Other's Bids override the Read Only setting for Bids List.

Database Table Explanation

Notice, in the screen below, the drop down list indicates Full Access, No Access, or Read Only privileges for each of the 5 different Database Tables.

Master Items

The Master Items options is not the same as Master. Master Items setting only control access to the Items list while Master access settings control the entire Master menu (see below).

Others' bids

Bids for which the Lead Estimator is not the current logged in estimator/Estimator. To set the Lead Estimator, open the Cover Sheet. All estimators that have a valid login are listed in the drop down list for Lead Estimator.

Bid List

The Bids Tab - a list of all bids/projects in the database. When "Others Bids" is selected, bids with "Lead Estimator" matching the current logged in user are affected.
If the logged in user has Read Only rights to the Bids list, they will not be able to CREATE new bids, but could edit existing bids.

Master

Anything listed when a user clicks Master from the main menu bar.

Payroll Classes

The Master Menu selection that brings up the Payroll Classes (Master) dialog.

Contact Support for any questions on how to properly configure and implement security settings.

Sharing Databases