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.