CONNX Data Integration Suite 14.8.0 | Operations Guide | Working with the Online CONNX Suite | Managing CDDs with the Online CONNX Data Dictionary Manager | Working with Tables in a CDD | Adding Table Restrictions
 
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.