Adding Table Restrictions
You can use the web based CDD manager to restrict the access level and methods of specific users to specific tables.
To add a restriction to a table:
1. Go to the main online CONNX Data Dictionary Manager page.
You can select CONNX Data Dictionary from the home page or the tile menu on the top right.
2. Open a CDD for editing.
3. Expand the database that contains the table you want to add a restriction to.
4. Select the table you want.
5. Select the Table Security tab.
6. Click the Add Restriction button.
7. Select the User or User Group you want to restrict from the dropdown menu.
8. Select the column you want to target with the restriction.
9. Mark the access you want to grant and click Save.
The access methods that do not have a checkmark are restricted for the selected users on the selected table. The access levels are as follows:

Select | The user(s) can run SELECT queries.
Update | The user(s) can update queries and modify existing data, but can not add new data.
Insert | The user(s) can insert new data.
Delete | The user(s) can delete data.
Drop | The user(s) can drop tables and keys to remove them completely.
Execute | The user(s) can execute stored procedures.
RFI | The user(s) can enable referential integrity.