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.

Ref: 1371