The following example File Access Definition includes three types of access: a default, a restricted table (CUSTOMERS), and a restricted column (ORDERS.ORDER_ID). The roles specified in the example are part of the PSTUSER Access Control Domain (ACD). The ACD validates the roles and associates them with users in your network.
For the first entry on the Table List, (Default), all roles and users, except the Guest role, are allowed to access tables in the Archive File that are not listed in Table List.

For the CUSTOMERS table, only the Optim™ Administrator role is allowed access. All other users and roles are denied access.

For the ORDERS table, all users, except the Guest role, are allowed access, but one or more columns have separate access permissions, as indicated by Column Secured setting.

As shown by the Table Access Control dialog, the Default AC Type grants all users Allow access. All users that can access the table are allowed to access columns not specified in the Column List.

However, only the Optim Administrator role can access the ORDER_ID column. All other users and roles are denied access.
