Privileges of DB User for FortiDB

This section indicate the privileges necessary for a target database user who connects FortiDB to the target database. This user name is used in the FortiDB Target connection page, in order to connect to the target database for Assessment, and DB Activity Monitoring.

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>

sp_addsrvrolemember 'username', 'sysadmin'

• Privileges for Assessment
  To run assessment, the FortiDB users for your target databases need the following privileges:
• Privileges for Monitoring Data
  
• Privileges for Monitoring Privilege
  
• Privileges for Monitoring Metadata