The security levels in all CDD entries can be modified to protect specific types of data. The access rights of individuals or groups can also be modified within the CDD. Users or groups can be added or removed, passwords can be changed, and security levels can be added to specific views.
Select a view from the list box in the CONNX Data Dictionary Manager window.
Click the View Security tab in the lower pane and then click the Add Restriction button.
To add a restriction to a view, select the name of the user or group to restrict in the User list box.
To add a restriction to a column, select the name of the column to restrict access to 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.
Select the check boxes in the remaining columns to define access rights for each user or group as described in the following table:
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 records. |
|
Delete |
Can delete data records. |
|
Drop |
Can drop tables and keys to remove completely. |
|
Execute |
Can execute stored procedures. |
|
RFI |
Can enable referential integrity. (Available in a future release.) |
Important: Individual security entries take precedence over group security entries.
