Dynamic tables: OPERATE privilege on upstream dynamic tables required for initial refresh (Pending)¶
This behavior change is in the 2023_08 bundle.
For the current status of the bundle, refer to Bundle History.
When you create a dynamic table that depends on upstream dynamic tables, you must have the following privileges on the upstream dynamic tables in order for the initial refresh to succeed:
- Before the change
Only SELECT privilege on the upstream dynamic tables is required.
- After the change
You must have OPERATE privilege on the upstream dynamic tables.
If you do not have OPERATE privilege, the initial refresh will fail with the following error:
OPERATE privilege is required on all upstream Dynamic Tables of '<table_name>' to perform a synchronous INITIAL refresh. Please acquire the right privileges.