Collecting Statistics on Tables Protected with Row-Level Security
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.