Home > Designing and creating solutions > Protecting databases > Managing privilege sets > Editing value list privileges

Editing value list privileges

Privilege sets can limit access to value lists in a file. For a file, you can set:

•	Privileges for all value lists: you can permit viewing, editing, and deleting of value lists, or viewing only.

•	Custom privileges for individual value lists: for each value list, you can set whether it is modifiable, view only, or accessible.

To edit privileges for all value lists:

1.	Start editing a new or existing privilege set in the Edit Privilege Set dialog box.

See Creating and editing privilege sets.

2.	In the Data Access and Design area, for Value Lists, choose All modifiable, All view only, or All no access. These options allow or prohibit the following:

•	All modifiable allows viewing and modifying value lists, duplicating and deleting value lists, and creating new value lists.

•	All view only allows viewing of existing value lists only. Prohibits opening the Manage Value Lists dialog box in order to create or edit value lists.

•	All no access prohibits seeing the items in all value lists. Prohibits accessing value list names in the Sort dialog box and other dialog boxes that display value list names. Prohibits opening the Manage Value Lists dialog box in order to create or edit value lists.

3.	Click OK, then click OK in the Manage Security dialog box.

Or, to assign the privilege set to one or more accounts, see Creating and editing accounts.

To edit privileges for individual value lists:

1.	Start editing a new or existing privilege set in the Edit Privilege Set dialog box.

See Creating and editing privilege sets.

2.

In the Data Access and Design area, for Value Lists, choose Custom privileges. In the Custom Value List Privileges dialog box, select each value list (or select Any New Value List to set privileges for any new value list created later) and set the privileges you want for it. When you’re through setting privileges for individual value lists, click OK.

 

To	In the Custom Value List Privileges dialog box
Allow viewing the value list, editing the value list, and deleting the value list	For Privilege, choose Modifiable.
Allow viewing of the value list only. Prohibits editing the value list in the Manage Value Lists dialog box.	For Privilege, choose View only.
Prohibit seeing the items in a value list. (The user will see <No Access> for the list instead of the value list items.) Prohibits editing the value list in the Manage Value Lists dialog box.	For Privilege, choose No access.
Allow creating new value lists and duplicating any viewable value list	Select Allow creation of new value lists.

Tip  You can also set individual privileges for multiple value lists at once by first selecting multiple value lists in the Custom Value List Privileges dialog box. See the Notes section below.

3.	Click OK, then click OK in the Manage Security dialog box.

Or, to assign the privilege set to one or more accounts, see Creating and editing accounts.

Notes

•

Setting a value list privilege to View only or choosing All view only prohibits opening the Manage Value Lists dialog box in order to create or edit value lists. However, even if a value list privilege is set to view-only, you can make a value list modifiable for users with the appropriate privileges: format the field object with the options that permit adding new value list items or editing existing value 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.