Use this procedure to perform DB access permission changes. After the changes are completed, users with access to the dbaccess group can run ODBC and JDBC clients and access the CMS database.
Procedure
Log in as root and run the cmsadm command.
Enter the number associated with the dbaccess option. The system displays the following message:
A message such as the following is displayed:
Begin CMS DB Access Permissions changes grant resource to "public";
Your CMS database currently has public access permissions to all resources.
Do you wish to revoke this access and only grant access to specific CMS
users? [y,n,?]
Enter y to proceed with changing database permissions.
The output displays grant connect to <cmslogin> for each CMS login ID in the dbaccess group.
Next Steps
To preserve your changes, run a CMSADM backup followed by a Maintenance Backup immediately.
