Collect Statistics on Protected Tables | VantageCloud Lake - Collecting Statistics on Tables Protected with Row-Level Security - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

If a table is protected by row-level security (at least one column is defined with a constraint-column-definition clause), you must have the OVERRIDE SELECT CONSTRAINT privilege to use COLLECT STATISTICS, HELP STATISTICS, and SHOW STATISTICS with the VALUES clause, as follows:

Object Required OVERRIDE SELECT CONSTRAINT Privilege
Base table On base table or database
Join index On underlying tables or database
View On view or database
Query On underlying tables or database

For copying statistics, you must have the SELECT privilege and, if the source table is protected by row-level security, the OVERRIDE SELECT CONSTRAINT privilege.