Get Live Help
How to get latest SQL Server, Oracle, DB2 database agent grant permissions scripts and Sybase first_run script?
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.
Navigate to Administration | Cartridges | Components for Download
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.