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.