15.10 - Requirements for Using the Open API - Teradata Database

Teradata Database Application Programming Reference

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1090-151K

The SQL interfaces to statistics management already exist if the TDSTATS database has been created by the DIPSTATS script as part of the Teradata Database installation.

You can use Teradata Studio or Teradata Studio Express to list the TDSTATS tables and views and view details about each view and table column. For information about Teradata tools and to download the tools, go to Teradata Developer Exchange.

Required Privileges

 

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.

Note: 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 about ...

See ...

the functionality of these open APIs

“Chapter 8 Automated Statistics Management API Features and Examples” on page 467.

the required privileges to run the Automated Statistics Management open APIs

“GrantPrivileges” on page 485.

each of the Automated Statistics Management open APIs

“Chapter 9 Automated Statistics Management APIs” on page 483.

Teradata Viewpoint

Teradata Viewpoint User Guide.