| GRANT EXECUTE PROCEDURE ON TDSTATS TO User
|
call the Automated Statistic Management open APIs. |
| GRANT SELECT ON TDSTATS TO User
|
query the TDSTATS database directly. If the Automated Statistics Management report open APIs (such as, AutomateReport, AnalyzeStatsReport, AnalyzeStatsUsageReport, and so on) are sufficient, you do not need to grant the SELECT privileges on the TDSTATS database.
|
| GRANT EXECUTE ON DBC.dbqlaccessmacro TO User
|
enable statistics usage logging. |
| GRANT STATISTICS ON User_Objects TO TDSTATS |
execute the AnalyzeStats or AnalyzeStatsUsage and RunCollect open APIs. |