CONNX Security Overview
The CONNX product has a comprehensive security model with the following features:
Established Security Measures Remain Intact
CONNX does not bypass security measures established by a database or operating system. For example, if a user has been given read-only access to a table, the user continues to have read-only access to the table through CONNX.
Secure Management
CONNX view, table, and column security levels can be assigned to an individual user, or to a group of users. Record security levels can be established through CONNX views.
Seven Access Levels
CONNX supports seven access levels:
Select | Read-only access |
Update | Update queries |
Insert | Insert new data |
Delete | Delete data |
Drop | Drop tables |
Execute | Execute stored procedures |
RFI | Enable Referential Integrity |
The access levels can be applied to a table object, a view object, or a field within a table or a view.
Integrated Security/Database Account Management
CONNX provides a mechanism that enables users to specify a single CONNX user name and password to access multiple databases that may each require a distinct user name and password. The database-specific identification information is encrypted and stored in the CONNX Data Dictionary.
Secure Data Dictionary
The CONNX Data Dictionary is encrypted to only allow access to authorized users.
Maximum Security Option
This option allows only users defined in the CONNX Data Dictionary to access data, regardless of database permissions.
Read Only Default Access Option
This option restricts all access to all tables in the CONNX Data Dictionary to Read Only. This default security level can be overridden by specifying User or Column level security in the Security Panel for each CONNX object.