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
Login to Subscribe
Please login to set up your
Would you like to be subscribed to future notifications for this article?
For security reasons, your link to this document has expired. Please click on the attachment link to access this file.
The attachment that you are looking for no longer exists.
There has been an issue retrieving your attachment. Please try again.
Currently server is down.
Get support for your product, with downloads, knowledge base articles, documentation, and more.
Maximize your product competency and validate technical knowledge to gain the most benefit from your IT investments.
Submit a suspected infected file to Symantec.
Report a suspected erroneous detection (false positive).
Set default language
Do you wish to save this as your future site?