Preparing to set secure database access

Last Updated : Sep 19, 2024 |

Procedure

  1. Review all CMS logins and determine which users need ODBC and JDBC access.

    You can view user permissions information in CMS Supervisor or by running the cms command.

  2. Make a note of which CMS logins need to be in the dbaccess group.

    You can run cat /etc/group | grep dbaccess to determine which users are already in the dbaccess group. For example, if the odbcusr1 and odbcusr2 are already in the group, a result such as the following is displayed:

    dbaccess::1002:odbcusr1,odbcusr2