Small Into To FileMaker Accounts & Privileges

From Dwayne Wright PMP, PMI-ACP, CSM
Certified FileMaker Developer

TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts

In FileMaker, you can protect a file with accounts and privilege sets. A user that opens the file can be required to enter in an account name and an associated password (previous to FileMaker 7, you only entered in a password).

NOTE: It is possible to have a no password account. Many times you would use a Guest Account for this. A guest account is automatically created for every new FileMaker file but is turned off by default.

Each account is assigned a privilege set. Privilege Sets consist of a large number of security settings ( much like a large lunch buffet ) and the combination of selected options define what a user can see or do. An account can have only one privilege set. A privilege set, however, could be assigned to many accounts and quite often is. A change in the privilege set can be applied to many different accounts and is quite handy when making sweeping security changes to a file.

The remainder of the FileMaker security settings flow from this humble beginning. When a user opens a protected FileMaker solution, they are asked for a user name and password. FileMaker authenticates this information when the user submits their data. If the account name and password match ... FileMaker assigns the privilege sets for that account ... the user enters the database system with a defined security layer. If the account name and password do not match ... FileMaker will deny access to the file and prompt the user to reenter their settings.

More info about the author and FileMaker in general, contact me at

© 2007 - Dwayne Wright -

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.