Collectors that use a database sensor require that you create a read-only database user account so that the collector can query for events.
See Installing collectors that use a database sensor.
To create a read-only database user account for IBM DB2
Log in as root to the computer with IDM DB installed.
To create a local user, at a command prompt, type the following command:
adduser user_name -g users -s /sbin/nologin
To set the password for the user db2test, type the following command:
To access the database command prompt, type the following command:
To connect to a DB2 alias, at the db2 command prompt, type the following command:
connect to db2_alias
For example, you can type the following command:
connect to SSIM
To grant connect privileges to the user user_name, type the following command:
GRANT CONNECT ON DATABASE TO USER user_name
To grant access to specific tables to the user db2test, type the following commands:
GRANT SELECT ON database_name.table_name TO USER user_name
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe
Thanks for your feedback. Let us know if you have additional comments below. (requires login)
This will clear the history and restart the chat.