Returning the CMS database to public permissions

Last Updated : Sep 10, 2024 |
Prolog information
Metadata
Keywords:
  1. To get the list of all ODBC users, enter: grep dbaccess /etc/group.
  2. You must first remove all users from the dbacess group. Run the usermod command for each CMS login that is currently in the dbaccess group.
    ADDITIONAL INFORMATION:
    Caution:
    Enter a capital G while typing the command. Entering a lower case g will changethe users default group, which can cause access issues to CMS.
    For example, if the users odbcusr1 and odbcusr2 are the entire set of CMS login IDs with secure access permissions.usermod -G "" odbcusr1 and usermod -G "" odbcusr2
  3. Enter: cmsadm
    STEP RESULT:
    The system displays the Avaya Call Management System Administration menu.
  4. Enter the number associated with the dbaccess option.
    ADDITIONAL INFORMATION: Begin CMS DB Access Permissions changes
    No CMS user ids are in UNIX group dbaccess.
    If you proceed, the CMS database is set to public permissions access for all
    resources.
    Do you really want to do this? [y,n,?]
  5. Enter: y
    ADDITIONAL INFORMATION: Please wait while CMS Informix Database permissions are set to public.
    grant resource to public;
    revoke connect from cms;
    revoke connect from cmssvc;
    Grant resource to public on CMS database.
    Changes to CMS DB Access Permissions finished.
    ADDITIONAL INFORMATION:
    Run a cmsadm backup followed by a Maintenance Backup to preserve your changes.