If a table is protected by row-level security (at least one column is defined with a constraint-column-definition clause), you must have additional privileges, as follows:
| To use COLLECT STATISTICS, HELP STATISTICS, and SHOW STATISTICS with the VALUES clause on... | You must have the OVERRIDE SELECT CONSTRAINT privilege on... |
|---|---|
| a base table | the base table or database. |
| a join index | the underlying tables or database. |
| a hash index | the underlying tables or database. |
| a view | the view or database. |
| a query | the underlying tables or database. |
For copying statistics, in addition to the SELECT privilege, you must have the OVERRIDE SELECT CONSTRAINT privilege if the source table is protected by row-level security.