Example: Index Analysis and Privileges - Analytics Database - Teradata Vantage

SQL Data Manipulation Language

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-05
dita:mapPath
pon1628111750298.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
esx1472246586715
lifecycle
latest
Product Category
Teradata Vantage™

Assume that you have the INSERT privilege on the IndexRecommendations and IndexColumns tables or on database QCD_name. The following INITIATE INDEX ANALYSIS request performs successfully.

     INITIATE INDEX ANALYSIS ON table_1
     FOR MyWorkload
     IN MyQCD
     AS table_1Index;

If you do not have INSERT privilege on MyQCD, the same request fails.

     INITIATE INDEX ANALYSIS ON table_1
     FOR MyWorkload
     IN MyQCD
     AS table_1Index;

Result:

     *** Failure 3523 The user does not have INSERT access to
     MyQCD.IndexRecommendations.