Granting Required Privileges | Application Programming Reference | Vantage - 17.10 - Granting Required Privileges - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Application Programming Reference

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1090-171K
Language
English (United States)
You must have the following privilege as part of your default role or it must be granted directly to you... To ...
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.

Related Information

For information on ... See ...
how to grant the EXECUTE PROCEDURE and SELECT privileges on the TDSTATS database GrantPrivileges.
how to grant the STATISTICS privilege on the qualifying user objects and TDSTATS database RunCollect.
the Automated Statistics Management report open APIs