-
Title
How to retrieve the grant privileges script for database agents (SQL Server, Oracle, DB2 and Sybase)? -
Description
How to get latest SQL Server, Oracle, DB2 database agent grant permissions scripts and Sybase first_run script?
-
Cause
The database agent include grant permissions scripts. These script are run automatically by the agent, in the agent configuration phase. The aim of the script it to provide the needed permissions and privileges on the database, so data can be gathered. The database user must have SYSADMIN rights for the script to run. This script itself can be extracted from within the agent for viewing ahead purposes or for running it manually (and not through the agent engine) against the Instance.
-
Resolution
The latest grant privileges scripts can be found in two locations:Navigate to Administration | Cartridges | Components for Download
- Download the DB_SQL_Server_CLI_Installer.zip file for the latest SQL Server cartridge
- Download the DB_Oracle_CLI_Installer.zip file for the latest Oracle cartridge
- Download the DB_DB2_Cli_Upgrade.zip file for the latest DB2 cartridge
- Download the DB_Sybase_firstRun_scripts.zip file for the latest Sybase cartridge
As well, when verifying an existing database agent or creating a new database agent and the installer determines that the database account does not have the necessary privileges the installer the installer will then provide a popup to grant privileges to the database account via a SYSADMIN level database account and a button will be present to open a second popup with the grant privileges script.
.png)
.png)
-
Attachments
-
Additional Information
Please follow that procedure for each agent version separately, as the script might have changed between versions.
