Removing ODBC access permissions for a specific user ID

Last Updated : Sep 10, 2024 |
Prolog information
  1. If you wish to remove any CMS login IDs from those designated to have ODBC/JDBC access permission, you must first remove them from the dbaccess group.
    ADDITIONAL INFORMATION:
    Note:
    You must execute usermod command once for each CMS login you are removing from the group.The usermod command will not remove the user from its default group cms.
    ADDITIONAL INFORMATION:
    For example, if you wish to remove the CMS login ID odbcusr1 from the dbaccess group: usermod -G ""odbcusr1.
    ADDITIONAL INFORMATION:
    Caution:
    Enter a capital G while typing the command. Entering a lower case g will change the users default group, which can cause access issues to CMS.
    ADDITIONAL INFORMATION:
    This command will remove the user from all the custom groups along with dbaccess.
  2. Enter: cmsadm.
    STEP RESULT:
    The system displays the Avaya Call Management System menu.
  3. Enter the number associated with the dbaccess option. The system reads the UNIX group information and resets the access permissions for only those members still in the dbaccess group.
    ADDITIONAL INFORMATION:
    For example, if you have removed odbcusr1 from the dbaccess group but left odbcusr2 in the group, then:Begin CMS DB Access Permissions changes
    Please wait while connect permissions are granted for requested users
    grant connect to “Odbcusr2”;
    Changes to CMS DB Access Permissions finished.
  4. To preserve your changes, run a cmsadm backup followed by a Maintenance Backup immediately.