OST - 20.06.01 Setting a Database to Require Login

Setting a Database to "Require Logins"

• Open Database Properties (right-click on the database in Bids Tab and select "Properties" , or click on Properties in the Open Databases dialog box)
• Click on the check box for Logins Required
• Enter in the user name and password for the database Administrator to adjust this setting

The database closes, then re-opens at the login screen.

• Enter in appropriate user name and password and click OK

Logging into a Secured Database

You can require users to log into a database to protect a database from unauthorized use. The database Administrator can assign specific Access Levels (above), limiting what a logged-in user can access. Access-levels and database-login go hand-in-hand to help you protect your database from unauthorized access/modification.

If a database is set to "Require Login", each user will be presented with the following Login screen, each time they open the database/program:

Check the Remember Login name and password check box if you don't want to enter your user name and password each time you launch the application.

When using logins, you will likely want to assign specific rights (Access Levels) to each Estimator to control what he or she can do in the database (see previous article for more information).

Using Access Levels to Restrict What Users Can Do

Multiple Concurrent Users in an SQL Databases (Database Sharing)