Topic group Related topics

dBASE Plus offers two general strategies to handle access to encrypted tables of any type: individual login and preset access.

Individual login via automatic password dialogs
In this approach, each user is required to login every time he or she tries to access a form linked to an encrypted table or database. dBASE Plus automatically displays a password dialog for the appropriate table type, requiring the user to enter a password or other information required by the table. Users might get different access levels, depending on their user name and password, and depending on the security features supported by the table type. The user must submit the correct information (which is passed to the encrypted database system for verification) before the user can access the dBASE Plus form.

Preset access via Session and Database objects
Preset access involves hard-coding passwords or user names in dBASE Plus forms and reports. Preset access provides an automatic, pre-determined level of access without login procedures for certain groups of users. It can be used in conjunction with individual login to provide easy read-only access for the public and login-protected access for authorized company personnel.

Preset access for Standard table types
Sessions objects provide unique connections between a user and a DBF or DB table. You can add methods to these objects to restrict access to certain features of a Standard table, or to make the table read-only for certain login-levels.

Preset access for SQL and other table types
Database objects link dBASE Plus forms to SQL databases or table sets. You can set the Database object’s loginString property for particular user names or passwords to limit users of a specific login-level to read but not write the data in an SQL database.

Table-level security for DBF tables
dBASE Plus supports direct access to the extended security features of DBF tables, including administrator security, up to 8 user access levels, and three-level privilege security for DBF tables and individual fields. If you intend to create tables within dBASE Plus, DBF tables offer the most extensive and versatile security features.

Table-level security for DB tables
dBASE Plus provides direct access to master password security for each DB table. However, you must use Borland’s Paradox or Database Desktop to set auxiliary passwords.