Important This space contains documentation for TrueSight Smart Reporting for Server Automation 20.02.01. For earlier releases, see TrueSight Smart Reporting for Sever Automation 19.2.

SQL database permission

A TrueSight Server Automation - Data Warehouse user needs the sysadmin privilege during the post-installation configuration of TrueSight Server Automation - Data Warehouse to complete the product installation and to perform the following tasks:

  • Adding sites
  • Archiving and restoring data
  • Reconfiguring TrueSight Server Automation - Data Warehouse to change the database server

Also, the TrueSight Server Automation - Data Warehouse user must be the owner of the TrueSight Server Automation - Data Warehouse database.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*