Use the File Access Definition Editor to define a File Access Definition. This dialog allows you to select an Access Control Domain to be used as the basis for the File Access Definition, select tables to secure using the Table List, and define access permissions for each selected table using the Table Access Control list. You can also define access permissions for columns in a listed table.
Open the File Access Definition Editor by selecting the menu option in the File Access Definitions dialog. You can also open that Editor for an existing File Access Definition by double-clicking a listing in the File Access Definitions dialog.

Enter text that describes the File Access Definition.
Type or select the name of an Access Control Domain (ACD) to use as the basis for the File Access Definition. The ACD translates the roles specified in the Table Access Control list into accounts in your network. After a File Access Definition is saved, you can select a different ACD by modifying the associated ACL.
(Default) and names of tables for which the File Access Definition explicitly controls access. Select an entry in the list to display or define corresponding access permissions in the Table Access Control list. The (Default) setting applies to archived data in tables not otherwise listed and cannot be deleted.

Type the fully qualified three-part name, or use Add Table from the shortcut menu to select a table name from a database or an Archive File. To remove a table name, select the row number and press Delete or use the Remove commands in the shortcut menu.
Any security settings for tables or columns that are not in the secured Archive File have no effect.
To define access permissions for columns, right-click the table entry and select List Columns from the shortcut menu. Column access permissions are defined in the Table Access Control dialog. Column Secured indicates a table with column access permissions defined.
Right-click a row in the Table List to display the following shortcut menu commands:
Select From Database to display the Select Table(s) dialog listing tables in the database. For more information, see Selecting Tables from a Database.
Select From Archive File to display the Open dialog, from which to choose an Archive File before displaying the File Access Definition Table/Column Selection dialog. For more information, see Selecting Tables from an Archive File.
Use the Table Access Control list to define access permissions for an entry in the Table List. You can assign access permissions to selected roles in the associated ACD and a default for all user accounts and roles for which access permissions are not assigned explicitly. If the AC Type for an entry in the Table List is None, Table Access Control list is blank and cannot be edited.
Type the name or use the drop-down list to select the name of a role defined in the ACD. You can also edit a role name. To remove a role name, use the Remove commands in the shortcut menu.
You must select either Allow or Deny for (Default). Roles for which both Allow and Deny are blank assume the permission selected for (Default).
Right-click the Table Access Control list to display the following shortcut menu commands:
Use the Select Table(s) dialog to select the names of one or more tables from a database referenced by a specified DB Alias. To open the Select Table(s) dialog, right-click the blank row at the bottom of the Table List, select Add table from the shortcut menu, and select From Database from the submenu. You can then select one or more table names to be added to the Table List.
The Select Table(s) dialog lists the database tables:
When you select Add table from the Table List shortcut menu, and select From Archive File from the submenu, the Open dialog is displayed to allow you to select an Archive File.
In the Open dialog, select the server on which the file resides and click Refresh. Use Look In to select the directory or path containing the file, and then double-click a listed file name or enter the file name and click Open. The names of tables in the selected file are listed in the File Access Definition Table/Column Selection dialog. Source indicates the path for the file.

Use the File Access Definition Table/Column Selection dialog to select the names of one or more tables in the Archive File. Click a table name to select it. To select multiple tables, hold the Ctrl or Shift key while clicking the table names. To select names of all tables in the Archive File, click Select All. Click OK to add the selected names to the Table List and display the File Access Definition Editor again.