Privileges required by the 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'