1. Select a table or view from the list box in the CONNX Data Dictionary Manager window.

2. Click the Table Security or View Security tab in the lower pane, and then click the Add Restriction button.

3. To add a restriction to a table or view, select the name of the user or group to restrict in the User list box.

4. To add a restriction to a column, select the name of the column to which you want to restrict access in the SQL Column list box. Select <All Columns> if the security entry is to apply to the entire table. Select <Everyone> and <All Columns> on all tables in order to maintain the highest levels of security.

5. Select the check boxes in the remaining columns to define access rights for each user or group as described in the following table.

CONNX CDD Definition of Access Rights

Access	Definition
Select	Read only - can run Select queries.
Update	Can update queries and can modify existing data, but not add new data.
Insert	Can insert new data.
Delete	Can delete data.
Drop	Can drop tables and keys to remove completely.
Execute	Can execute stored procedures.
RFI	Can enable referential integrity. (Not available in this release.)

Related Topics

CONNX Security Overview

Adding Security to a Data Dictionary Entry

Accessing multiple databases

Managing Applications