The CMS database has open access permissions as a standard feature. That is, any CMS login connecting to the CMS server using ODBC/JDBC has permissions to view CMS data tables.
Note:
CMS does not allow you to control which tables the CMS login has access to, or which ACD data the CMS login can view.
To limit the users that can access the
CMS database using ODBC/JDBC follow the steps listed in this section. The users for whom you set permissions must adhere to the following requirements:
All CMS login IDs to which you choose to provide CMS database access must be members of the dbaccess group.
You must execute the dbaccess option under the cmsadm menu, which makes the proper Informix permission changes to the CMS database.
Your secure access permissions are preserved for you in the
cmsadm backup and in the
CMS Maintenance backup. The permissions are migrated during a
CMS upgrade and can be restored in the event of a loss of your
CMS server data.
