20 FileMaker Pro Web Publishing Security Guidelines
You can limit users' access to records based on their department within a company, their job
position, or other criteria. For example, if you have a database accessed by managers and
salespeople, you can provide different levels of access to these users. Each record in the database
includes the field AccessType, and this field has the value of either
Manager
or
Sales
, thereby
determining which group has access to the record. Users who are part of the Sales group will be
allowed to access only those records where AccessType has the value of
Sales
. Users who are
part of the Manager group will be allowed to access both types of records, where AccessType has
the value of either
Sales
or
Manager
.
Here's an example of setting limited access to certain records in a database:
1.
Choose
File
menu
> Define Fields.
2.
Type
AccessType
into the
Field Name
area, verify that the field type is
Text
, and click
Create
.
This field will store the access type for each record.
3.
Click
Done
.
4.
Choose
File
menu
> Access Privileges > Passwords
.
Note
If you see the
Change Password
command instead of the
Access Privileges
command, you have
opened the file as a guest, or with a password that provides limited access. To create the additional
passwords explained in this example, you must reopen the file as the host, with a master password.
If your database does not have any passwords defined, you will need to define a password with full
access privileges before continuing. See the FileMaker Pro
User's Guide
or the FileMaker Pro
online help for more information.
5.
Type
sales_password
in the Password area. Do not click
Create
.
6.
In the
Privileges
area, verify that
Browse records
is selected
.
7.
Choose
Limited
from the list next to the
Browse records
privilege.
8.
In the
Specify calculation
dialog box, type the calculation:
AccessType = Sales
This calculation will determine if access is granted to this record. Access is allowed if the result of
the calculation is True, and access is denied if the result of the calculation is False.
9.
Click
Done
to save the calculation.
10.
Repeat steps 5 through 8 to create the same level of limited access for record editing and record
deletion privileges.
11.
Click
Create
to create the password sales_password with the privileges described above.
12.
Define the manager password by typing
manager_password
in the
Password
area. Do not
click
Create
.
13.
In the
Privileges
area, select
Browse records.
14.
Choose
Limited
from the list next to the
Browse records
privilege.
15.
In the
Specify calculation
dialog box, type the calculation:
AccessType = Sales OR AccessType = Manager