Help

Protecting databases
F
ILEMAKER PRO HELP 464
• To continue working with accounts and privileges, see Creating and managing
accounts, Creating and managing privilege sets, or Managing extended privileges.
Editing record access privileges
Privilege sets can limit access to records in a file. For a file, you can set:
• Privileges for all tables: you can limit whether a privilege set allows creating, editing, and
deleting records in all the
tables in a file.
• Custom privileges for individual tables: you can set individual record access limits for each
table. For example, the privilege set can limit the ability to:
• View, edit, create, or delete all records in each table.
• View, edit, and delete certain records within each table. The privileges are limited by
means of calculation that returns a
Boolean result for each record. When the calculation
evaluates to True, access is allowed for that specific activity (such as viewing the
record). When the calculation evaluates to False, access to that activity is prohibited.
• Access or modify certain fields within each table. When access to one or more fields is
restricted in a table that is otherwise visible, the user will see <No Access> instead of
the field data.
You can only set record access privileges for tables defined in the current file. If the file contains
relationships to tables in other files that you want to protect, you need to create
accounts and
privilege sets in the other files to protect those tables. See About protecting databases.
To edit record access privileges:
1. Start editing a new or existing privilege set.
See Creating new privilege sets or Editing existing privilege sets.
2. In the Edit Privilege Set dialog box, choose one of the following options from the Records
list:
3. In the Custom Record Privileges dialog box, select one or more tables for which you want to
edit custom privileges. (Or select Any New Table to set privileges for any table created
later.)
The Custom Record Privileges dialog box displays the tables in the file and the custom
privileges for each table. To change the privileges, you start by selecting the tables that you
want to change, and then you choose privileges in the Set Privileges area at the bottom of the
dialog box.
To edit the privilege set to Choose
Permit creating, editing and deleting records in all
tables
Create, edit, and delete in all tables, and skip
ahead to step 10.
Permit creating and editing records only (prohibit
deleting records) in all tables
Create and edit in all tables, and skip ahead to
step 10.
Permit viewing records only (prohibit creating,
editing, and deleting records) in all tables
View only in all tables, and skip ahead to step
10.
Prohibit accessing records in all tables All no access, and skip ahead to step 10.
Create custom record access privileges for
individual tables
Custom Privileges, and continue with the next
step.