Secure Access to Data on Multiple Platforms

Security can be established in each database, although RMS and DBMS databases do not support column-level security. Such security can only be accomplished through CONNX. Additional security can be established in tables in CONNX using the CONNX Data Dictionary. CONNX can then restrict access at the column or table level for any user or all users. See To add security to tables and columns for information on adding security to tables and columns.

The creation of CONNX Views can also be used to limit access to data. This mechanism enables a database administrator to establish security on a cross-platform view, consisting of tables in different databases. See Security for CONNX Views for more information on CONNX Views.