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 CONNX Views in a CDD | Adding CONNX View Restrictions
 
Adding CONNX View Restrictions
You can use the web based CDD manager to restrict the access level and methods of specific users to specific views.
*To add a restriction to a view:
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. Select the CONNX Views tab from the top of the page.
4. Select the View Security tab.
5. Click the Add Restriction button.
6. Select the User or User Group you want to restrict from the dropdown menu.
7. Select the column you want to target with the restriction.
8. 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 view. 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 views and keys to remove them completely.
Execute
The user(s) can execute stored procedures.
RFI
The user(s) can enable referential integrity.