Connecting to target databases : Privileges required by the FortiDB database user
 
Privileges required by the FortiDB database user
 
When you configure a target that allows FortiDB to connect to a target database, you specify a database user. This user requires specific privileges to allow it to perform assessments or monitor database activity.
To grant privileges to the FortiDB user, use the GRANT statement. For example:
GRANT SELECT_CATALOG_ROLE TO <username>
GRANT SELECT ON dbo.syscolumns TO <username>
GRANT SELECT ON SYSIBM.SYSCOLAUTH TO <username>
GRANT ROLE SSO_ROLE TO <username>
For Microsoft SQL Server, use the following command to add a login as a member of sysadmin:
sp_addsrvrolemember '<user name>', 'sysadmin'
See also
Privileges for VA assessments, privilege summaries, and penetration tests
Privileges for monitoring data
Privileges for monitoring privileges
Privileges for monitoring metadata
Adding (or modifying) a target connection