Preparing to set secure database access

Last Updated : Sep 19, 2024 |
Prolog information
  1. Review all CMS logins and determine which users need ODBC and JDBC access.
    ADDITIONAL INFORMATION:
    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.
    ADDITIONAL INFORMATION:
    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