Granting Required Privileges - Teradata Database - Teradata Vantage NewSQL Engine

Application Programming Reference

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-02
dita:mapPath
vwf1492987142269.ditamap
dita:ditavalPath
changebar_rev_16_20_exclude_audience_ie.ditaval
dita:id
B035-1090
lifecycle
previous
Product Category
Teradata Vantageā„¢
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 Topics

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