Help

Protecting databases
F
ILEMAKER PRO HELP 468
would no longer be able to view, edit, or delete the record once he or she exits that record.
Because changes are committed as soon as a user exits a record, a user making changes
of this type will not be able to return to the record. (In most cases, you should base record
access calculations on fields that are not directly editable by users, such as auto-entered
fields that contain account names, creation dates, and modification dates.)
Also, if the file is shared and the Boolean calculation that determines record access privileges
contains one or more global fields, you may be able to improve network performance by moving
some global fields into a separate table. See the Notes section in Defining global fields (fields
with global storage).
• To fully support multiple windows that have their own found sets, summary values are a part
of the found set. (There is no single summary value for a single file as in FileMaker
Pro 6
and earlier versions.) A record may appear in multiple windows, and each window has its
own found set and sort order. For these reasons, do not base privilege calculations on
summary or Get functions that rely on values using a particular found set.
Editing layouts privileges
Privilege sets can limit access to layouts in a file. For a file, you can set:
• Privileges for all layouts: you can allow or prohibit the ability to switch to Layout mode and
make design changes to all layouts. You can also prohibit access to all layouts in a file.
• Custom privileges for individual layouts: you can set two types of access limits for each
layout:
• Design and view limits for each layout: whether the privilege set permits making design
changes to a layout in Layout mode, view-only layout access, or no layout access at all.
• Data access limits for each layout: whether the privilege set permits accessing, viewing,
or modifying data displayed by each layout. When access to data is prohibited, the user
can view the layout but will see
<No Access> instead of any field data.
Note There are important distinctions and interactions between layouts privileges and record
access privileges:
• Although you can use layout privileges to limit access to data, these settings protect only a
single view of data on a layout by layout basis, which may not protect all instances of the
data. To limit access to all occurrences of specific tables, records, or fields no matter where
they are displayed or accessed, use record access privileges. See
Editing record access
privileges.
• Even if you use layout privileges to allow viewing and editing of data, record access
privileges still apply and may limit access to certain tables, fields, and records.
For a comparison of how layouts privileges and record access privileges work together, see How
layouts privileges and record privileges interact.
To edit layouts privileges:
1. Start editing a new or existing privilege set.
Display the Edit Privilege Set dialog box. See Creating new privilege sets or Editing existing
privilege sets.
2. To set privileges for all layouts in the file, for Layouts, choose All modifiable, All view
only, or All no access. These options allow or prohibit the following: