Adding Security to a Data Dictionary Entry
The CONNX Integrated Security feature simplifies the process of logging on to multiple databases by using the same alias for one or more databases. CONNX prompts for a user name and password. If connecting to a single database, the logon name and password used can be the same as the one used with a source database.
To access multiple databases, use one of the database login credentials as the CONNX user credentials. You can also create an entirely new user name and password for accessing the CONNX Data Dictionary (CDD).
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, columns, or tables within each type of database.