Help

Protecting databases
F
ILEMAKER PRO HELP 472
list items (or both). See Setting up a field to display a pop-up menu, checkbox set, or other
control.
• You can select multiple value lists in the Custom Value List Privileges dialog box in order to
set privileges for multiple value lists at once:
• To select multiple value lists, Ctrl-click (Windows) or Command-click (OS X) each value
list name.
• To select a range of adjacent value lists, click the first value list, and then Shift-click the
last value list in the range.
• To select all value lists, click Select All.
• To change the order of the value lists displayed in the Custom Value List Privileges dialog
box, click one of the column headings to order the list by that column. To switch between
ascending and descending order, click the column heading again.
• For value lists with ODBC data, the No access privilege and Limited custom privilege are
not supported. To prohibit a user from seeing ODBC data in a value list, you must enforce
row-level security in the external SQL database.
Editing scripts privileges
Privilege sets can limit access to scripts in a file. For a file, you can set:
• Privileges for all scripts: you can allow or prohibit the ability to view, create, and modify
scripts. You can also hide all the scripts in a file to prevent them from being run by the
privilege set.
• Custom privileges for individual scripts: you can set whether each script is modifiable or not.
You can also hide a script to prevent it from being run by the privilege set.
Note Although some script privileges described below allow the ability to run scripts, the actions
permitted by a privilege set determine whether the steps in a script will execute successfully or not.
For example, if a privilege set does not permit accessing a Salary field, then a script containing the
Go to Field [“Employees::Salary“]
script step will fail. The script author can override
script privilege issues by selecting Run script with full access privileges in the Edit Script window.
To edit script privileges:
1. Start editing a new or existing privilege set.
Open the Edit Privilege Set dialog box. See Creating new privilege sets or Editing existing
privilege sets.
2. To set privileges for all scripts in the file, for Scripts, choose All modifiable, All executable
only, or All no access. These options allow or prohibit the following:
Privilege
All
modifiable
All
executable only
All no
access
Running scripts Allowed Allowed Prohibited
Viewing script names in the Scripts menu
(except those that are hidden by clearing Include in
menu in the Manage Scripts dialog box)
Allowed Allowed Prohibited
Opening the Manage Scripts dialog box to view, create,
group, filter, edit, duplicate, delete, and print scripts
Allowed Prohibited Prohibited
Allow scripts to be imported into other database files Allowed Prohibited Prohibited