Home > Designing and creating databases > Protecting databases > Creating and managing privilege sets > Editing scripts privileges

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. For more information, 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
Viewing script steps in the FileMaker Pro Advanced Script Debugger and Database Design Report	Allowed	Prohibited	Prohibited

3.

To set individual privileges for each script in the file, for Scripts, choose Custom privileges. In the Custom Script Privileges dialog box, select each script (or select Any New Script to set privileges for any script created later) and set the privileges you want for it. When you’re through setting privileges for individual scripts, click OK.

 

To	In the Custom Script Privileges dialog box
Allow running, viewing, editing, printing, and deleting the script. (Also allow the script to be imported into other database files.)	For Privilege, choose Modifiable. Note  Even if the script is modifiable, you cannot modify a script that runs with Full Access privileges unless your account is assigned the Full Access privilege set. For more information, see Creating and editing scripts.
Allow running the script only. (Prohibit viewing the script in the Manage Scripts dialog box.)	For Privilege, choose Executable only.
Prohibit running or viewing the script. (The script name will not appear in the Scripts menu.)	For Privilege, choose No access.
Allow creating new scripts and duplicating any modifiable script	Select Allow creation of new scripts.

Tip  You can also set individual privileges for multiple scripts at once by first selecting multiple scripts in the Custom Script Privileges dialog box. For more information, see the Notes section below.

4.	In the Edit Privilege Set dialog box, define any other privileges for the privilege set.

For details on the different privileges you can define, refer to one or more of the following topics:

•	Editing record access privileges

•	Editing layouts privileges

•	Editing value list privileges

•	Editing extended privileges for a privilege set

•	Editing other privileges

5.	When you’ve finished editing this privilege set, click OK.

6.	In the Manage Security dialog box, do one of the following:

•	If you’ve finished working with accounts and privileges, click OK. In the dialog box that appears, enter an account name and password that is assigned the Full Access privilege set, and click OK.

•	To assign the privilege set to one or more accounts, see Creating accounts or Editing existing accounts.

Notes

•

In the Custom Script Privileges dialog box, the Notes column indicates which scripts run with Full Access privileges. Depending on what these scripts do, you may want to set Executable only or No access script privileges for them in certain privilege sets. For more information on running scripts with Full Access privileges, see Creating and editing scripts.

•	You can select multiple scripts in the Custom Script Privileges dialog box in order to set privileges for multiple scripts at once:

•	To select multiple scripts, Ctrl+click (Windows) or Command-click (Mac OS) each script name.

•	To select a range of adjacent scripts, click the first script, and then Shift-click the last script in the range.

•	To select all scripts, click Select All.

•	To change the order of the scripts displayed in the Custom Script 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.

•	You can open multiple Edit Script windows at one time. For more information, see Creating and editing scripts.