Dynamic tables: OPERATE privilege on upstream dynamic tables required for initial refresh¶

Attention

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.

Ref: 1371