You must have the privileges listed below to access Database Expert functions and modules.
To create and drop indexes in the Index Advisor and Index Impact Analyzer, you must have the privilege to create and drop indexes.
You must have sa_role to:
Use SQL Collector for the Monitor Server module
Terminate the Run Result function when the SQL statement produces a result set in the SQL Optimizer and SQL Worksheet modules
Access the dbcc traceon information
To optimize a SQL statement that is used in a cursor in the Syntactical SQL Optimizer, you must have the privilege to create a procedure.
You must have the mon_role to access the SysSQLText and monSysStatement monitoring tables to use:
SQL Inspector
Performance Monitor
