Setting field privileges

Topic group Related topics

With DBF tables you can establish access for each field by user access level. The following table describes the available field privileges.

Privilege	Access granted
FULL	View and modify the field. This is the default.
READ-ONLY	View the field only (no update capability).
NONE	No access. The user can neither read nor update the field, and the field does not appear.

Note

Table privileges take precedence over field privileges. For example, if a table privilege is set for Read but not Update, the only meaningful field privileges are Read-Only or None. You must restrict table privileges to protect your data against table-oriented commands like DELETE and ZAP. Restricting field privileges to Read-Only or None without restricting table privileges doesn’t protect data against these commands.

The Fields list in the dialog box lists all of the fields in the current table. The Rights buttons display the field privileges for the selected field for access levels 1 through 8. Initially, all field privileges are set to Full.

Follow this procedure to change a field privilege:

Select the field.
Click the Rights buttons that correspond to the privileges you want to grant for the field for each access level.
Repeat the process for each of the other fields in the table.
Click OK to save the field access privileges.

Warning!

Never change the access rights of the _DBASELOCK field of any table. The rights to this field must remain Full for all access levels.