Each CMS login which receives ODBC/JDBC access must be a member of the UNIX dbaccess group.
ADDITIONAL INFORMATION:
Note:
The root, CMS, and cmssvc users will have full default permissions to ODBC/ JDBC.
To put CMS logins into the dbaccess group, enter: usermod -G dbaccess cmslogin where cms login is the user id of the specific CMS login to be placed in the group. You must execute the usermod command once for each CMS login to which you want to provide CMS database access.
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.
