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