Help

Protecting databases
F
ILEMAKER PRO HELP 465
• To select one table, click its name.
• To select multiple tables, Ctrl-click (Windows) or Command-click (OS X) each name.
• To select a range of adjacent tables, click the first name, and then Shift-click the last
name in the range.
• To select all tables, click Select All.
4. To set custom privileges for viewing, editing, creating, and deleting records, choose one of
the following options from the View, Edit, Create, and Delete lists in the Set Privileges
area:
Note Avoid creating inconsistent combinations of view, edit, create, and delete privileges. For
example, you most likely do not want to permit users to delete records that they cannot view.
5. To limit access or modification of certain fields within a table, continue with the next step.
Otherwise, skip ahead to step 9.
6. Select the table that contains the fields for which you want to limit access. Then, for Field
Access, choose Limited.
7. In the Custom Field Privileges dialog box, select each field for which you want to limit
access (or select Any New Field to set custom privileges for any field created later). Then
choose one of the following options:
8. Click OK.
9. Click OK.
You see the Edit Privilege Set dialog box.
10. Manage any other privileges for the privilege set.
For details on the different privileges you can define, see:
• Editing layouts privileges
• Editing value list privileges
• Editing scripts privileges
Choose To
Yes Allow the privilege (viewing, editing, creating, or deleting records).
Limited (available when
only a single table is
selected)
Allow or prohibit the privilege (viewing, editing, and deleting records)
for certain records within the table.
In the Specify Calculation dialog box, enter a calculation, and click
OK. See
Entering a formula for limiting access on a record-by-record
basis, below.
No Prohibit the privilege (viewing, editing, creating, or deleting records).
Choose To
Modifiable Allow viewing and editing of the field data.
View only Allow viewing of the field data. (Editing of field data is not allowed.)
No access Prohibit access to the field.
Note When access to one or more fields is prohibited in a table that is otherwise
visible, the user will see
<No Access> instead of the field data.