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. (See CONNX Views).

 

Seven Access Levels

CONNX supports seven access levels: Select, Update, Insert, Delete, Drop, Execute, and RFI.
 

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.

Related Topics

Adding Security to a Data Dictionary Entry

To add security to tables and columns

CONNX Users and Groups