Topic group Related topics

Although DB tables do not offer the extensive user the access-level and privilege- level security system available to DBF tables, DB tables (unlike DBF tables) support passwords.

You can use dBASE Plus to assign master passwords to DB (Paradox) tables. Once you have assigned a master password assigned to a DB table, it cannot be opened without supplying the password, either by you locally or by users over the Internet.

You may choose to create a single master password that opens all DB tables. A user with this password need see only one password dialog to gain access to all DB tables. Or you may set unique passwords for particularly sensitive DB tables.

Note

In addition, auxiliary passwords are supported by DB tables, but you cannot access this feature from dBASE Plus. Auxiliary passwords allow you to create multiple individual passwords for each DB table, so that you can restrict access to certain tables and certain fields. Different users can be given different passwords that will open only a specific set of DB tables or allow read/write access to only certain fields within those tables. However, to set auxiliary passwords for field rights to a DB table you must use Paradox.

The process of assigning passwords is initially very similar to that described previously for DBF tables. To assign a master password to a DB table, follow these steps:

  1. Make sure the DB table you want to secure is closed.

  2. From the File menu, select Database Administration. The Database Administration dialog box appears.

  3. Make sure that the Current Database field is set to <None> and the Table Type field is set for Paradox (DB) tables.

  4. Click the Security button to open the Security dialog box.

  5. Select the name of the table in the Table list. If the table is not in the current directory, use the Folder button to select the directory.

  6. Click the Edit Table button to open the Master Password dialog box.

  7. Enter the new password for the table in the Master Password field. The password can be up to 31 characters long and can contain spaces. Paradox passwords are case-sensitive.

  8. Enter the password again in the Confirm password field.

  9. Click the Set button to save the password.