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.
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.
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 |
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 | For Privilege, choose No access. |
Allow creating new value lists and duplicating any viewable value list | Select Allow creation of new value lists. |
•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.
•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.