Use primary role for authorizing view and materialized view creation (Pending)

Attention

This behavior change is in the 2024_08 bundle.

For the current status of the bundle, refer to Bundle History.

When this behavior change bundle is enabled, the creation of a view or materialized view behaves as follows:

Before the change:

When creating a view or materialized view, the primary and all secondary roles are considered when checking the privileges of the SQL definition.

After the change:

When creating a view or materialized view, only the primary role is considered when checking the privileges of the SQL definition.

Ref: 1782