Managing IBM DB2 Databases › Registering IBM DB2 Databases › Grant Database Privileges to the CA SRM User

Grant Database Privileges to the CA SRM User

to successfully collect data from DB2 databases, the CA SRM user performing the collection needs to have certain privileges on the DB2 databases. A script is provided with CA SRM to grant these privileges automatically.

To grant the privileges on a database using the script

1. Connect to the DB2 database as a user that has SYSADM or BDADM privileges.
2. Locate the script. By default, the script is installed to the following location:

   C:\BrightStor SRM Data\Database\Configuration\GrantPrivilegeDB2User.sql
   

3. (Optional) By default, the script grants privileges to the user "BrightStorSRM". If you want to grant privileges to a different user, change all instances of "BrightStorSRM" to the name of the user.
4. Execute the script.

   The necessary privileges are granted to the specified user.

   Note: If you run this script against DB2 UDB v8.1, it is normal to receive the following error for a few of the commands:

   GRANT OR REVOKE is not defined for system objects
   

5. Repeat this procedure for each DB2 database from which you want to collect data.