User manual
Table Of Contents
- Preface Introducing FileMaker Pro
- Chapter 1 Using databases
- About database fields and records
- Opening files
- Opening multiple windows per file
- Closing windows and files
- Saving files
- About modes
- Viewing records
- Adding and duplicating records
- Deleting records
- Entering data
- Finding records
- Making a find request
- Finding text and characters
- Finding numbers, dates, times, and timestamps
- Finding ranges of information
- Finding data in related fields
- Finding empty or non-empty fields
- Finding duplicate values
- Finding records that match multiple criteria
- Finding records except those matching criteria
- Deleting and reverting requests
- Viewing, repeating, or changing the last find
- Hiding records from a found set and viewing hidden records
- Finding and replacing data
- Sorting records
- Previewing and printing databases
- Automating tasks with scripts
- Backing up database files
- Setting preferences
- Chapter 2 Creating databases
- Chapter 3 Working with related tables and files
- Chapter 4 Sharing and exchanging data
- Chapter 5 Protecting databases with accounts and privilege sets
- Chapter 6 Converting FileMaker databases from previous versions
- Index
84 FileMaker Pro User’s Guide
Note The Full Access privilege set is the only one that permits
access to the Define Database and Define File References dialog
boxes in order to modify fields, tables, relationships, and file
references. It is also the only privilege set that permits changing
accounts and privileges. Because you cannot enable these privileges
in any other privilege set, any user that wants to make database
definition changes or privileges changes must open the file with an
account that is assigned the Full Access privilege set.
At least one active, FileMaker authenticated account in each file
must be assigned the Full Access privilege set. An error message will
appear if you edit accounts so that no active account is assigned the
Full Access privilege set.
Planning security for a file
A new FileMaker Pro file is initially unprotected. Whenever the file
opens, it automatically logs in the user with the Admin account,
which is assigned the Full Access privilege set.
1 If you simply want to keep someone else from opening a database
file on your computer, you can password-protect the file. For more
information, see
“Password-protecting a file” on page 85.
1 If you need to share a database file with others and provide varying
levels of file access to different users, you need to plan the security
for the file.
To plan the security for a shared file:
1. Determine the privilege sets that you need for the file.
Make a list of the areas of the file that you want to protect, such as
particular tables, fields, records, layouts, value lists, and scripts. Plan
the number of privilege sets you need to enforce the varying levels
of file access that you require.
2. Determine whether you need individual accounts for each user, or
group accounts that multiple users can share.
3. Decide if you want to enable the Guest account, which permits
users to open the file without specifying account information.
4. Create the privilege sets that you need in the file.
5. Determine if you need to enable any extended privileges for
certain privilege sets.
Don’t enable extended privileges unless they’re needed.
6. Create the accounts you need in the file, and assign the appropriate
privilege set to each account.
For more information, see the next section. If you’re using the Guest
account, assign a privilege set to it as well. Otherwise, disable the
Guest account.
Override data validation
warnings
on off off
Disconnect user from
FileMaker Server when
idle
off on on
Allow password
modification
on on on
Password change
number of days
off off off
Minimum password
length
off off off
Available menu
commands
all all all
Privilege Sets
Privilege Full Access
Data Entry
Only
Read-Only
Access